INDEX_COLUMNS View¶

This Account Usage schema view displays a row for each column in the indexes defined in the specified (or current) database.

Columns¶

Column Name	Data Type	Description
ID	NUMBER	ID of the column.
NAME	TEXT	Name of the column.
INDEX_ID	NUMBER	ID of the index.
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	TEXT	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.
KEY_SEQUENCE	NUMBER	Position of the column in the index.
INDEX_OWNER	TEXT	Owner of the index.
IS_UNIQUE	TEXT	With `YES` or `NO`, indicates whether this index is a unique index.
IS_INCLUDED_COLUMN	TEXT	With `YES` or `NO`, indicates whether this column is covered by an index.
CONSTRAINT_NAME	TEXT	Name of the constraint that is associated with this index.
STATUS	TEXT	Status of this index.
CREATED	TIMESTAMP_LTZ	Time of creation for this index.
DELETED	TIMESTAMP_LTZ	Date and time when the hybrid table was dropped.
OWNER_ROLE_TYPE	TEXT	The type of role that owns the object, either `ROLE` or `DATABASE_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.

Latency for the view may be up to 180 minutes (3 hours).