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¶

Column Name	Data Type	Description
ORGANIZATION_NAME	VARCHAR	Name of the organization.
ACCOUNT_LOCATOR	VARCHAR	System-defined identifier for an account.
ACCOUNT_NAME	VARCHAR	User-defined identifier for an account.
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 the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.
DELETED	TIMESTAMP_LTZ	Date and time when the schema was dropped.
OWNER_ROLE_TYPE	TEXT	The 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_TYPE	VARCHAR	Specifies the schema type. Valid values are: . . - STANDARD: normal schema. . - VERSIONED: versioned schema.
VERSION_NAME	TEXT	Name of the schema if it is a versioned schema. NULL otherwise.
VERSIONED_SCHEMA_ID	NUMBER	Internal/system-generated identifier if the schema is a versioned schema. NULL, otherwise.
OBJECT_VISIBILITY	OBJECT	A specification that is set on the object.
REPLICABLE_WITH_FAILOVER_GROUPS

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.