- Schema:
SCHEMATA View¶
This Account Usage view displays a row for each schema in the account except the ACCOUNT_USAGE, READER_ACCOUNT_USAGE, and INFORMATION_SCHEMA schemas.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
SCHEMA_ID |
NUMBER |
Internal/system-generated identifier for the schema. |
SCHEMA_NAME |
TEXT |
Name of the schema. |
CATALOG_ID |
NUMBER |
Internal/system-generated identifier for the database of the schema. |
CATALOG_NAME |
TEXT |
Database that the schema belongs to. |
SCHEMA_OWNER |
TEXT |
Name of the role that owns the schema. |
RETENTION_TIME |
NUMBER |
Number of days that historical data is retained for Time Travel. |
IS_TRANSIENT |
TEXT |
Whether the schema is transient. |
IS_MANAGED_ACCESS |
TEXT |
Whether the schema is a managed access schema. |
DEFAULT_CHARACTER_SET_CATALOG |
TEXT |
Not applicable for Snowflake. |
DEFAULT_CHARACTER_SET_SCHEMA |
TEXT |
Not applicable for Snowflake. |
DEFAULT_CHARACTER_SET_NAME |
TEXT |
Not applicable for Snowflake. |
SQL_PATH |
TEXT |
Not applicable for Snowflake. |
COMMENT |
TEXT |
Comment for the schema. |
CREATED |
TIMESTAMP_LTZ |
Date and time when the schema was created. |
LAST_ALTERED |
TIMESTAMP_LTZ |
Date and time when the schema was last altered. |
DELETED |
TIMESTAMP_LTZ |
Date and time when the schema was dropped. |
OWNER_ROLE_TYPE |
TEXT |
The type of role that owns the object, either |
Usage Notes¶
Latency for the view may be up to 120 minutes (2 hours).
The view only displays objects for which the current role for the session has been granted access privileges.