Snowsight - Databases: Schema Details

When you select a schema in the database object explorer, the schema details page page appears.

This section provides a brief overview of how to navigate and use the database details page.

Interface

Description

Basic schema details

Basic details about your schema are located at the top of the page.

Schema details tabs

The schema details page includes the following tabs:

  • Schema Details

  • Tables

  • Views

  • Stages

  • File Formats

  • Data Pipelines

  • Functions

  • Procedures

More menu

The More menu, located in the upper-right corner of the page, lets you do the following:

  • Edit

    Edit the schema name and comment.

  • Clone

    Clone the schema.

  • Drop

    Drop the schema.

  • Transfer Ownership

    Transfer ownership of the schema to another role.

Create object

In the upper-right corner of the page, select Create to create database objects for the schema.

When you select an object to create, a worksheet opens. Snowsight provides template SQL to create the object you selected.

Schema Details Tab

The Schema Details tab includes the following sections:

  • Privileges

Use the Privileges section to view, grant, and revoke privileges on the schema.

Objects Tab

The schema details page provides a tab for each type of database object. Pipes, stages, and tasks are collected on the Data Pipelines tab.

To view details about an object, on the table, select an object.

In the upper-right corner of the table, use the Search box to find objects. Some object tabs also provide filters.

The Tables tab includes the following filters:

  • All Tables (default)

  • Tables

  • External Tables

The Views tab includes the following filters:

  • All Views (default)

  • Views

  • Materialized Views

  • Materialized Secure Views

  • Secure Views