Schema:

ORGANIZATION_USAGE

SCHEMATA view

Important

This view is only available in the organization account. For more information, see Premium views in the organization account.

This Organization Usage view displays a row for each schema in an account except the READER_ACCOUNT_USAGE, and INFORMATION_SCHEMA schemas.

Columns

Organization-level columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization.
ACCOUNT_LOCATORVARCHARSystem-generated identifier for the account.
ACCOUNT_NAMEVARCHARUser-defined identifier for the account.

Additional columns

Column NameData TypeDescription
SCHEMA_IDNUMBERInternal/system-generated identifier for the schema.
SCHEMA_NAMEVARCHARName of the schema.
CATALOG_IDNUMBERInternal/system-generated identifier for the database of the schema.
CATALOG_NAMEVARCHARDatabase that the schema belongs to.
SCHEMA_OWNERVARCHARName of the role that owns the schema.
RETENTION_TIMENUMBERNumber of days that historical data is retained for Time Travel.
IS_TRANSIENTVARCHARWhether the schema is transient.
IS_MANAGED_ACCESSVARCHARWhether the schema is a managed access schema.
DEFAULT_CHARACTER_SET_CATALOGVARCHARNot applicable for Snowflake.
DEFAULT_CHARACTER_SET_SCHEMAVARCHARNot applicable for Snowflake.
DEFAULT_CHARACTER_SET_NAMEVARCHARNot applicable for Snowflake.
SQL_PATHVARCHARNot applicable for Snowflake.
COMMENTVARCHARComment for the schema.
CREATEDTIMESTAMP_LTZDate and time when the schema was created.
LAST_ALTEREDTIMESTAMP_LTZDate and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.
DELETEDTIMESTAMP_LTZDate and time when the schema was dropped.
SCHEMA_TYPEVARCHARSpecifies the schema type. Valid values are:

- STANDARD: normal schema.
- VERSIONED: versioned schema.
OWNER_ROLE_TYPEVARCHARThe type of role that owns the object, for example ROLE.
If a Snowflake Native App owns the object, the value is APPLICATION.
Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.
SCHEMA_TYPEVARCHARType of schema. Possible values are STANDARD and VERSIONED.
VERSION_NAMEVARCHARName of the schema if it is a versioned schema. NULL otherwise.
VERSIONED_SCHEMA_IDNUMBERInternal/system-generated identifier if the schema is a versioned schema. NULL, otherwise.
OBJECT_VISIBILITYOBJECT

OBJECT_VISIBILITY

Snowflake logo in black (no text) Preview Feature — Open

Available to all accounts.

This property controls the discoverability of the objects in the account, enabling users without explicit access privileges to find objects and request access.

Usage notes

  • Latency for the view may be up to 24 hours.
  • The view only displays objects for which the current role for the session has been granted access privileges.

  • The LAST_ALTERED column is updated when the following operations are performed on an object:

    • DDL operations.
    • DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
    • Background maintenance operations on metadata performed by Snowflake.