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 details about your schema are located at the top of the page. |
|
The schema details page includes the following tabs:
|
|
The More menu, located in the upper-right corner of the page, lets you do the following:
|
|
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