Starburst Galaxy

  •  Get started

  •  Working with data

  •  Data engineering

  •  Developer tools

  •  Cluster administration

  •  Security and compliance

  •  Troubleshooting

  • Galaxy status

  •  Reference

  • Explore clusters #

    A cluster in Starburst Galaxy is a set of compute nodes that can be started and run to provide access to catalogs of data sources. The cluster provides the resources to run queries against multiple catalogs. You can access the data exposed by the catalogs with the query editor or with another supported client.

    Cluster list #

    To see the list of clusters in your Galaxy account, click Admin > Clusters on the navigation menu. Learn about exploring individual clusters from the cluster list as described on the clusters page.

    Cluster explorer pane #

    Explore the data entity contents of each available cluster using the cluster explorer pane, which is part of the query editor.

    cluster explorer

    The cluster explorer pane shows an expandable, hierarchical diagram with the following symbols:

    clusters cluster status symbol
    catalogs logo for this catalog’s data source
    schemas hub symbol
    tables table symbol
    views eye symbol
    columns two-column table symbol

    The cluster status symbols are:

    Solid Running
    Pulsed Starting
    Solid Suspended
    Solid Stopped

    For short durations, you can also see the status Updating if you made an edit to a cluster’s configuration, such as changing its size or auto-suspend time.

    Expand a cluster to see the cluster’s entities such as catalogs, schemas, tables, views, and materialized views regardless of the cluster’s status. Entities remain visible when the cluster is suspended.

    To expand an element, click its expander icon. To collapse an element, click its collapse icon.

    Click a cluster’s name to collapse all catalogs under it. Similarly, click a catalog to collapse all schemas under it, and click a schema to collapse its table and view list.

    Quick info dialogs #

    Click or hold the pointer over the name of a cluster in the cluster explorer to display an information dialog that shows the status, size, cluster type, owner, cloud, and region for the selected cluster. For example:

    Click cluster name

    Click or hold the pointer over the name of a table in the cluster explorer to show the full path of the table, including cluster name. For example:

    Click table name

    Click or hold the pointer over the name of a column in the cluster explorer to display a dialog that shows the type, the default value, and whether the data is nullable for the selected column. For example:

    Click column name

    You can select and copy text within a quick info dialog. Click to copy the name or full path to a cluster object in the clipboard. Click to open the cluster explorer page to see details about a specific cluster object. For example:

    Click arrow up right from square icon

    Options menus #

    The cluster explorer displays an ( ) options menu on the right of an object’s name when you select or hold the pointer over its name. The selections in the options menu apply only to the current object. The following example shows the options menu for a table named “customer”:

    Three dots for table

    The following table shows the menu options provided by the options menus for cluster explorer objects.

    Object menu options
    Cluster
    Select cluster
    Sets this cluster as the default for this editor tab, which places the name of this cluster in the location drop-down menus.
    Catalog
    Copy name to clipboard
    Places the quoted catalog name in the clipboard. Example: "tpch"
    Select catalog
    Sets this catalog as the default for this editor tab, which places this catalog name in the location drop-down menus.
    View details
    Opens the catalog explorer page for this catalog in a new browser tab.
    Run discovery
    On catalog entries for [object storage](../create-catalogs/object-storage/index.html) data sources only, opens the catalog explorer pane for this catalog, with the Schema discovery tab open and ready to use.
    Schema
    Copy full path to clipboard
    Places the quoted path to this schema in the clipboard. Example: "tpch"."sf1000"
    Generate SQL for this data
    Opens the Generate SQL from text pane.
    Select schema
    Sets this schema and its catalog as the defaults for this editor tab.
    Enter SHOW CREATE SCHEMA
    Places the statement SHOW CREATE SCHEMA quoted-schema-path; in the first available editor pane and selects the line.
    View details
    Opens the catalog explorer page for this schema in a new browser tab.
    Table
    Copy full path to clipboard
    Places the quoted path to this table in the clipboard. Example: "tpch"."sf1000"."customer"
    Generate SQL for this data
    Opens the Generate SQL from text pane.
    Enter SELECT * from tablename LIMIT 10;
    Places the statement SELECT * from quoted-table-path LIMIT 10 in the first available line in the editor pane, and selects the line.
    Enter DESCRIBE tablename
    Places the statement DESCRIBE quoted-table-path; in the first available editor line and selects the line.
    Enter SHOW CREATE TABLE tablename
    Places the statement SHOW CREATE TABLE quoted-table-path in the first available editor line and selects the line. See Examine table parameters for more information.
    View details
    Opens the catalog explorer page for this table in a new browser tab.
    View Same options as for a table, with the word view substituted.
    Column
    Copy name to clipboard
    Places the quoted column name in the clipboard. Example: "custkey"
    Enter SELECT columnname from tablename LIMIT 10;
    Places the statement SELECT columnname from quoted-table-path LIMIT 10 in the first available line in the editor pane, and selects the line.
    View details
    Opens the catalog explorer page for the table that contains this column in a new browser tab.

    Examine table parameters #

    Use the SHOW CREATE TABLE statement to examine the structure of a table and reveal its creation parameters. This is especially useful for tables in object storage, where you may need to see a table’s type and format.

    The options ( ) menu for tables includes the SHOW CREATE TABLE statement for the current table. When run, the result appears in the results pane:

    Query editor show create table dialog

    In the options menu for a view or materialized view, invoke the SHOW CREATE VIEW statement. As with tables, click the long line in the results pane to open a dialog that shows the CREATE VIEW parameters for the current view. For example:

    Query editor show create view dialog