Insights Worksheet query editor#

Starburst Insights includes Worksheet as a visual workbench to run ad hoc queries and explore configured data sources.

Editor pane#

Use the editor pane to type in the query you want to execute, and press the Run ▶ button or Ctrl+Enter(⌘+Enter on Mac) to run your query.

The editor pane includes drop down selectors for the active catalog (disk symbol) and schema (hub symbol). You can optionally select a single schema, or a single schema and a single table to have them set as defaults for the duration of the session in the IDE.

Query editor dropdowns

The menu includes a Copy to clipboard option, and a Prettify option to format your query, adding spaces, tabs and newlines where needed.

Multiple tabs can be opened to keep queries organized and allow multitasking. You can start a long-running query in one tab, and switch to another tab to work on something else while your query is executing. The query in the hidden tab continues to run, and displays results when it completes. At the same time you can run additional queries in other tabs.

Note that the contents of the various tabs are persisted only until the window or tab is closed.

Catalog browser pane#

Catalog browser

The Catalog browser pane displays an expandable, hierarchical view of catalogs (disk symbol), schemas (hub symbol) and tables and views (grid symbols) configured in SEP. To expand an element, click its > expander arrow. To collapse an element, click its v collapsed arrow. You can click on a catalog to collapse all schemas under it. Similarly, you can click on a schema to collapse its table list.

Results pane#

When your query is finished executing, the result set appears in the table below the editor pane.

Above the results table on the left, the status bar displays current query statistics:

  • Status - Display progress while the query is processed, and final status when complete

  • Avg. read speed - From all sources, in rows per second

  • Elapsed time - Since query processing started

  • Rows - The number of rows returned

While running, a progress estimate is shown:

Query in progress

If your result set is very wide, or is greater than 1000 rows, it is truncated.

Truncated result set

On the right above the results, complete details on a query’s history, including performance statistics and execution plan, are available by clicking on the Query details link in the status bar:

Query results links

You can use the Web UI link to get access to information such as a query’s live plan and performance for the current stage of live queries.

Once a query has completed, a Download link appears for the results set in the table. Results are not stored, and are only available until a new query is run or your page is closed or refreshed, whichever comes first.

Query results links