starburst galaxy > catalog explorer > Tables and views

Tables and views #

Note: Support for catalog explorer is provided as a public preview. It is an early access feature release available for all users but not supported for production environments.

The third level of catalog explorer is the tables and views level which contains a number of elements that relate to a table or a view. All views available in the catalog explorer are views native to the underlying database.

Data asset metadata #

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

Click the pencil icon to edit table or view metadata. Table and view metadata can only be edited by the table or view’s owner. Metadata is otherwise read-only. If the table or view does not have an assigned owner and the parent schema does, then the table or view inherits the schema’s owner. If the parent schema does not have an assigned owner, table and view ownership is inherited from the catalog. Owner inheritance is denoted by a right-facing enter key icon preceding the owner icon.

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

Description displays the description of the table or view, if any.
Source comment displays the table or view’s comment, if any. Source comment is read-only.
Tags lists the tags associated with the table or view. Apply tags to the table or view to enable attribute-based access control policies.
Contacts displays users who can provide information and support for the table or view. You can add any user with a role that owns the table or view directly, or indirectly.
Owner displays the owner of the table or view.

Overview #

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

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.

Columns #

The Columns page displays a list of columns found within the table or view 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 shown:

Name lists the name of each column.
Type lists the datatype of the column.
Nullable lists if the column accepts null values.
Default lists the default value of the column.
Tags lists the tags associated with the column. Apply tags to the column to enable attribute-based access control policies. Click + to add or remove tags.
Description displays the description of a column, if any. Click the pencil icon to edit the description.

Definition #

The Definition pane displays the results of a SHOW CREATE TABLE or SHOW CREATE VIEW statement.

Click the Edit icon to open the statement in the query editor.
Click the Copy icon to copy the statement to the clipboard.
Click the Expand icon to view the full query text.

Data preview #

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

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

Query history #

The Query history pane shows a list of queries that accessed this table or view. Look for queries that occurred within a pre-defined date range using the Dates menu on the right.

Query history is limited to your role’s history unless your current role is accountadmin or your role has the View all query history privilege.

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 pane displays an audit trail of administrative actions related to this catalog and its schemas, tables, views, and columns. Your current role must have the View audit log privilege in order to see audit log entries from all users.

The following columns are shown:

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.

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.