Catalogs #

The first level of catalog explorer is the catalogs level which contains a number of elements that relate to a catalog:

Data asset metadata #

You can view and edit metadata associated with your catalog, such as a description, the catalog’s owning role, and a list of user contacts.

Catalog metadata can only be edited by the catalog’s owner. Metadata is otherwise read-only.

Click Show details to see an expanded view of the catalog’s metadata:

catalog explorer catalog metadata

  • Description displays the description of the catalog. Click the pencil icon to edit the description.
  • Owner displays the owner of the catalog. Click the pencil icon to change the owner.
  • Contacts displays users who can provide information and support for the catalog. You can add any user with a role that owns the catalog directly, or indirectly.

Overview #

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

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

You may add a catalogs to one or more clusters by using the Add to cluster button, selecting the clusters from the menu, and clicking Add clusters.

Schemas #

The Schemas page displays a list of schemas found within the catalog.

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

Click the name of a schema to open the Overview page for that schema.

Query history #

The Query history page shows a list of queries that access the catalog. You may view queries in a pre-defined date range using the Date(s) menu on the right.

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.

Audit log #

The Audit log page displays the audit trail of all administrative actions performed by all users that are related to the catalog and nested schema, tables, and columns.

The following columns are displayed:

  • Operation: The configuration change that was performed. Possible values include update, delete, suspend, and others depending on the object.
  • Object: The type of object, such as catalog or schema, for which the configuration was changed.
  • Object name: The name of the specific object.
  • What changed: A description of the changed attributes including values.
  • User: The user who performed the change.
  • Time of change: The date and time the change was performed.

More information is available in the global audit log.

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 and ownership rights.

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