Query editor overview #

Query editor offers a full environment to write and execute SQL statements. You can access all running clusters and the configured catalogs.

Access the query editor at any time by clicking Query editor on the left hand menu. Alternatively, you can use the Query item in the options in the list of clusters.

Separate query editor tabs #

You can rename a tab by double-clicking on the tab name. The + button can be used to create another tab.

Cluster explorer #

Each tab contains the cluster explorer panel on the left. Use it to explore the available clusters, catalogs and schemas.

Editor panel #

The editor panel allows you to type one or more SQL statements. Use the Run button to execute a single statement in the editor. If the editor contains multiple statements, highlight a specific statement to be able to execute it.

The right hand corner above the editor contains a drop down selector for the cluster. You can optionally select a default catalog and schema for your queries in the editor. The USE catalog.schema statement can alternatively set these defaults.

Additional available commands include the following:

  • Copy to transfer all the text from the editor to the clipboard
  • Prettify to improve the formatting of all statements in the editor
  • Command palette to access a list of further available command

Results panel #

The results panel below the editor displays the query processing progress and results. Typically one or more rows and columns are returned by a query.

The Web UI button can be used to access the query processing details.

The Download button can be used to request a CSV file of the data.