CLASSES view¶

Important

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

Organization Usage performance

When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in Performance (Organization Usage): bound every scan on history views, list columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.

This Organization Usage view displays a row for each class in the account.

Columns¶

Organization-level columns

Column Name	Data Type	Description
ORGANIZATION_NAME	VARCHAR	Name of the organization.
ACCOUNT_LOCATOR	VARCHAR	System-generated identifier for the account.
ACCOUNT_NAME	VARCHAR	User-defined identifier for the account.

Additional columns

Column Name	Data Type	Description
ID	NUMBER	Internal/system-generated identifier for the class.
NAME	VARCHAR	Name of the class.
SCHEMA_ID	NUMBER	Internal/system-generated identifier for the schema of the class.
SCHEMA_NAME	VARCHAR	Name of the schema the class belongs to.
DATABASE_ID	NUMBER	Internal/system-generated identifier for the database of the class.
DATABASE_NAME	VARCHAR	Name of the database the class belongs to.
OWNER_NAME	VARCHAR	Name of the role that owns the class.
OWNER_ROLE_TYPE	VARCHAR	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.
CREATED	TIMESTAMP_LTZ	Date and time when the class was created.
DELETED	TIMESTAMP_LTZ	Date and time when the class was deleted.
COMMENT	VARCHAR	Comment for the class.

Usage notes¶

Latency for the view may be up to 24 hours.

Examples¶

The following example finds all classes in the account:

SELECT account_name, name, database_name, schema_name
  FROM snowflake.organization_usage.classes;