Starburst Documentation
Starburst Galaxy
  •  Get started
  •  Working with data
  •  Data engineering
  •  Developer tools
  •  Cluster administration
  •  Security and compliance
  •  Troubleshooting
  • Galaxy status
  •  Reference

    • starburst galaxy > working with data > query data > Use query results

    Use query results #

    The results returned from a query are shown in the results pane in the bottom part of the query editor.

    Results pane #

    The results pane shows the progress of the query processing and the results. Typically, one or more rows and columns are returned by a query.

    Query editor results pane

    • Adjust your view of the results pane:

      • Click the expand_circle_down down arrow to close the results pane or the expand_circle_up up arrow to open it.
      • Click and drag the border between the editor and results panes to resize the results pane.

    • Monitor the query process from the status bar, which displays current query processing statistics:

      • Status: Displays the progress of the querying process, and then the final status when complete, whether it is finished, cancelled, or failed.
      • Avg. read speed: Calculates from all sources, in rows per second.
      • Elapsed time: Calculates, in seconds, from when the query process started.
      • Rows: The number of rows returned.
      • Results from cache: Indicates whether results were read from cached results instead of the data source.
      • Cached at: Displays the point in time when results were cached. This statistic is only visible in the status bar if results were read from the cache.

      While a query is running, a progress estimate for that query is shown. If your result set is very wide or is greater than 1000 rows, it is truncated.

    • Utilize the active links:

      • widgets Opens a dialog to create a data product from a query. See Create a data product for more details.
      • visibility Opens the details page for the most recently run query.
      • open_in_new Opens the Trino web UI. To see details, the cluster must be running.
      • vertical_align_bottom Downloads results as a CSV file, if results are shown from the last query. Results are not stored, and are only available until a new query is run or your page is closed or refreshed, whichever comes first.

    Learn more #