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, 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 180 minutes (3 hours).