- Schema:
TABLE_
This Account Usage view displays whether Snowflake Optima Metadata, Indexing, or Clustering is applied to each table in the account. Use this dictionary view with TABLE_QUERY_PRUNING_HISTORY view and AUTOMATIC_CLUSTERING_HISTORY view to report on Optima feature use and query optimization benefits.
Each row represents a table and indicates which Optima capabilities apply to that table.
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| TABLE_ID | NUMBER | Internal/system-generated identifier for the table. |
| TABLE_NAME | VARCHAR | Name of the table. |
| SCHEMA_ID | NUMBER | Internal/system-generated identifier for the schema that contains the table. |
| SCHEMA_NAME | VARCHAR | Name of the schema that contains the table. |
| DATABASE_ID | NUMBER | Internal/system-generated identifier for the database that contains the table. |
| DATABASE_NAME | VARCHAR | Name of the database that contains the table. |
| OPTIMA_METADATA_APPLIED | BOOLEAN | Indicates whether Snowflake Optima Metadata is applied to the table. |
| OPTIMA_INDEXING_APPLIED | BOOLEAN | Indicates whether Snowflake Optima Indexing is applied to the table. |
| OPTIMA_CLUSTERING_APPLIED | BOOLEAN | Indicates whether Snowflake Optima Clustering is applied to the table. |
Usage notes¶
- Users and roles that have been granted the OBJECT_VIEWER database role can access this view. For more information, see SNOWFLAKE database roles.