Skip to main content
Use the Browse Data screen to explore and query any source or target connection. From here you can run ad-hoc SQL, download the results, or turn your SQL into a new Custom mapping.

​
Choose Connection

Use the pull-down to select one of the connections defined in the Manage Connections screen. The Explore Connection tree is loaded for the selected connection.

​
Explore Connection

The Explore Connection panel shows the objects in the selected connection as a folder tree: schema, then Tables and Views, then the table or view, then its columns. Use it to find the objects you need and to help write your query.
  • Click the ▸ arrow next to an item to expand it and drill down from schema to table to columns.
  • Right-click a table or view to show the Script as Select option.
  • Script as Select generates a SELECT statement listing every column of the table and places it in the SQL editor.
  • You can run the query as is, or edit it first.
  • Drag any column from the tree and drop it into the SQL editor to insert its name at the cursor.
  • Click the refresh button refresh to re-read the connection and pick up structural changes — new or dropped tables and files, added, removed or renamed columns, and so on.

​
Enter SQL Statement

Type any SQL supported by the selected connection into the editor, or build the query using Script as Select and drag-and-drop as described above. The editor provides syntax highlighting and line numbers.
  • Click Format Format to reformat the statement so it is easier to read.
  • Click Run to execute the statement, or use the keyboard shortcut.
Shortcut to run the queryMac: ⌘ + ReturnWindows: Ctrl + Enter
The drop-down arrow next to Run provides two more actions:
  • Download runs the statement and downloads the result set through your browser as a comma-delimited (CSV) file. The download is limited to 10,000 rows.
  • Generate Map sends the statement to the Generate Mapping screen as a Custom Query, where you choose the target connection and create the mapping.

​
Results

When you click Run, the result set appears in the Results panel below the editor. The number of rows shown is limited by the maxrows setting in the [DataExplorer] section of setup.cfg (default 1,000); use Download to retrieve larger result sets.
  • Use entries per page to change the number of rows shown per page.
  • Use Search to filter the rows shown to those containing a value.
  • Click a column heading to sort by that column.
  • Use the Previous, Next and page-number controls at the bottom of the panel to move through the pages.
Click the Results heading to collapse or expand the panel. The Enter SQL Statement heading collapses the editor in the same way, which is useful when reviewing a wide result set.