Schema:
ACCOUNT_USAGE

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.

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.