Using the Database Explorer in Aginity Pro

Viewing the Database Data Dictionary

Once you have established a connection to a database you can browse the database dictionary catalogs. You can toggle to the Database Explorer browser by clicking on the tab as shown below. The database data dictionaries typically contain the tables, columns, views, and other database objects available to query from the query panel.

Once you have selected the Database Explorer tab you can drill into each connection as shown below.

Quick Actions from Explorer

Currently, you can do the following quick actions from the Database Explorer

SQL Statement Generation

To generate typical SQL statements from tables or views you can right-click on the object, navigate to scripts and choose the appropriate script as shown below.

Selective SQL Generation on a Set of Columns

To generate SQL statements based on a selection of columns within a Table or View, multi-select the columns by holding Ctrl (Windows) or Command (Mac) and selecting the columns as shown below. Then generate the SQL statement.

Hint
Make sure you don’t have the table name selected and column names at the same time. If you do it will generate the SQL for the whole table.

Note
Double-clicking expands the DB Explorer tree

Copy JDBC Connection String

If you select any Connection (Top level of the tree) and select “Copy Connection string to Clipboard” you will get the full JDBC URI which is helpful for debugging. See this Knowledge Base Article for help with debugging your Aginity Pro connections.