Starburst Galaxy

  • Starburst Galaxy Home
  •   Get started
  •   Global features
  • Help center
  • Release notes
  • Feature release types

  • Starburst Galaxy UI
  •   Query
  •   Catalogs
  •   Catalog explorer
  •   Data products
  •   Clusters
  • Partner connect
  •   Admin
  •   Access control
  •   Cloud settings

  • Administration
  •   Security
  •   Single sign-on
  •   Troubleshooting
  • Galaxy status

  • Reference
  •   Python
  • API
  •   SQL
  •   Tutorials
  • Catalog explorer #

    The catalog explorer gives you a way to browse through the metadata of a catalog and to drill down to analyze schemas, tables, views, materialized views, and columns within that catalog. You can see which schemas and tables exist, and see what columns and data they contain. This helps you create queries using the information you discover.

    Access the catalog explorer #

    Access the catalog explorer with two steps:

    • In the navigation menu, click Catalogs.

    • Browse through the catalog explorer pane to the catalog, schema, table, or view of interest. The path to the current selection is shown in boldface in the explorer pane.

    You can also click a catalog name in the list of catalogs, then drill down to a schema, table, or view in the explorer results pane on the right.

    Use the search field to narrow the list of entities to those that match your search term.

    If your Starburst Galaxy account includes one or more data products, use the data products filter button to restrict the catalog explorer pane to the entities associated with your data products.

    Data products filter button

    Catalog explorer pane #

    Use the catalog explorer pane to explore the catalogs, schemas, tables, views, and columns of the current cluster. This is similar to the cluster explorer feature of the query editor, but here restricted to the currently selected cluster.

    Use the close icon to collapse the catalog explorer; click the expander arrow to re-open it. The catalog explorer remains in its last open or closed position on restart.

    catalog explorer pane

    The catalog explorer pane shows an expandable, hierarchical view with the following symbols:

    catalogs logo for this catalog’s data source
    schemas
    tables
    views
    columns

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

    Catalog level #

    The catalog level contains a number of tabs that lead to information about the currently selected catalog:

    Schema level #

    The schema level contains a number of tabs that lead to information about the currently selected schema:

    Table or view level #

    The table or view level contains a number of tabs that lead to information about the currently selected table or view: