The query editor offers an interactive environment for querying data and running data management SQL statements.
Go to the query editor from anywhere in Starburst Galaxy by clicking Query > Query editor in the navigation menu, or selecting Query data from the options menu in several locations, including the list of clusters.
The query editor consists of a canvas area and the cluster explorer pane on the left. The canvas is split among several tabs that provide an editable space where you can write and run SQL statements. The cluster explorer pane lists the clusters available in your Galaxy account and their configured catalogs. The editor pane as a whole has several menus, which are described in the following sections.
The left corner above the editor pane contains drop-down menus that let you specify a cluster, catalog, and schema as default settings for SQL statements in the current editor tab. These settings are analogous to the SQL USE statement.
The selections in these menus persist for each tab separately, and are restored when you reopen a saved query editor tab.
If you have more than one cluster in your Starburst Galaxy account, you must select a cluster in order to activate the Run button. When you open a new tab, the cluster selection is empty and a message reminds you to select a cluster before querying.
A green dot in the cluster drop-down menu means the specified cluster is currently running.
To the right of the Run button is anmore_vertoptions menu that shows the following options:
Each query editor tab contains a context menu you can activate in the standard ways: right-click on a right-hand configured mouse, double tap on a trackpad, and so on. The context menu allows you perform the following actions:
You can create, edit, and organize query editor tabs, which are automatically stored as Saved queries.
You can overwrite the contents of the current tab or organize your queries into separate tabs. To create a new tab, click the button at the end of the tab row. Drag and drop tabs to rearrange them.
The default name for newly created query tabs is the date and time of creation. To rename a tab in the query editor, double-click the tab name.
Timestamped query tabs and named query tabs persist across login sessions until the tab is closed. After the tab is closed, timestamped query tabs are stored for a particular duration of time as described in Saved queries.
Is the information on this page helpful?
Yes
No