Tables #

The third level of catalog explorer is the tables level which contains a number of pages that relate to a table:

Overview #

The Overview page displays a visual analysis of important metrics about the table:

catalog explorer charts

Use the Date(s) drop down above the chart to view data for different time intervals.

The following metrics across all clusters are displayed:

  • The Queries over time chart shows the absolute number of run, queued, and failed queries.
  • The Top users chart shows the most active users by processed queries, by used CPU time, by data read, or by data written.
  • The Top sources chart shows the most active sources, so client applications like the query editor, the Trino CLI, and others by processed queries, by used CPU time, by data read, or by data written.
  • The Top tables chart shows the most active tables and views by processed queries, by data read, or by data written.

The Clusters table shows a list of clusters, and the following information about each cluster:

  • Name shows the name of the cluster.
  • Status displays the status.
  • Catalogs lists the configured catalogs used in the cluster.
  • Region displays the region of the cloud provider.
  • Owner displays the role that owns the entity.
  • Connection provides details to use to connect clients to the cluster.

catalog explorer clusters

Columns #

The Columns page displays a list of columns found within the table and relevant information for each of them.

You may refresh the list of columns, or search through the list by using the Refresh button on the left, or the Search columns field on the right, respectively.

The following columns are displayed:

  • Name lists the name of each column with a clickable link to open the Overview page of that column.
  • Type lists the datatype of the column.
  • Nullable lists if the column accepts null values.
  • Default lists the default value of the column.

Data preview #

The Data preview page allows you to view a preview of the data found in a table.

To preview the data of a table, select a cluster from the Select cluster menu and click on Preview data:

data preview

Query history #

The Query history page shows a list of all queries that access the table. You may view queries in a pre-defined date range, or use the View full history option to view all queries.

Query history is limited to your role’s history unless you are accountadmin or your permissions are set to view all queries.

catalog explorer query history

Click Refresh to reload queries in the list.

The following columns are displayed:

  • Status uses for successfully completed queries, and for failed queries.
  • Query ID shows the unique identifier for each query; click the ID to open the Query details pane for the query.
  • Cluster is the name of the cluster used to process the query.
  • Query text displays the full or partial SQL text of the query.
  • Email identifies the user who submitted the query.
  • Role specifies the name of the role used by the user when submitting the query.
  • Create date uses the browser timezone and shows the start date and time of the query processing.
  • Elapsed time is the total duration for processing the query.

Privileges #

User accounts with permission to view privileges have access to the Privileges page. The Privileges page allows you to view privileges based on account role.

The following columns are displayed:

  • Role specifies the name of the role.
  • Privileges shows the privileges for the role.

Use the Add privileges button to add or remove access to a privilege:

  1. Select a role from the menu.

  2. By default, new privileges allow access rights, but you can click the deny switch to create a deny privilege.

  3. Select the privileges to grant to the current role, and click the Add privileges button to save the privilege grants.

catalog explorer privileges