Schema:

For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).

INDEXES 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 index defined in each account in your organization.

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	ID of the index.
NAME	TEXT	Name of the index.
TABLE_ID	NUMBER	ID of the hybrid table.
TABLE_NAME	TEXT	Name of the hybrid table.
SCHEMA_ID	NUMBER	ID of the schema to which the hybrid table belongs.
SCHEMA_NAME	TEXT	Schema to which the hybrid table belongs.
DATABASE_ID	NUMBER	ID of the database to which the hybrid table belongs.
DATABASE_NAME	TEXT	Database to which the hybrid table belongs.
OWNER	TEXT	Owner of the hybrid table.
IS_UNIQUE	TEXT	With `YES` or `NO`, indicates whether this index is a unique index.
CONSTRAINT_NAME	TEXT	Name of the constraint that is associated with this index.
STATUS	TEXT	Latest status of this index.
CREATED	TIMESTAMP_LTZ	Time of creation for this index.
DELETED	TIMESTAMP_LTZ	Date and time when the index 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.

Usage notes¶

Latency for the view may be up to 5 hours.