- Schemas:
SEMANTIC_TABLES view¶
This ACCOUNT_USAGE view displays a row for each logical table defined in a semantic view.
Columns¶
Column name |
Data type |
Description |
|---|---|---|
|
NUMBER |
Internal, Snowflake-generated identifier for the table in the semantic view. |
|
VARCHAR |
Name of the table in the semantic view. |
|
NUMBER |
Internal, Snowflake-generated identifier for the semantic view in which the table is defined. |
|
VARCHAR |
Name of the semantic view in which the table is defined. |
|
NUMBER |
Internal, Snowflake-generated identifier for the schema that the semantic view belongs to. |
|
VARCHAR |
Schema that the semantic view belongs to. |
|
NUMBER |
Internal, Snowflake-generated identifier for the database that the semantic view belongs to. |
|
VARCHAR |
Database that the semantic view belongs to. |
|
VARCHAR |
Name of the base table. |
|
VARCHAR |
Schema that the base table belongs to. |
|
VARCHAR |
Database that the base table belongs to. |
|
ARRAY(VARCHAR) |
List of the primary key columns of the table. |
|
ARRAY(VARCHAR) |
List of the synonyms for the table. |
|
VARCHAR |
Comment for the table. |
|
TIMESTAMP_LTZ |
Creation time of the table. |
|
TIMESTAMP_LTZ |
Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes. |
|
TIMESTAMP_LTZ |
Date and time when the table was dropped. |
Usage notes¶
Latency for the view can be up to 120 minutes (2 hours).
The LAST_ALTERED column is updated when the following operations are performed on an object:
DDL operations.
DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
Background maintenance operations on metadata performed by Snowflake.
Examples¶
Retrieve the list of all logical tables for the semantic view O_TPCH_SEMANTIC_VIEW in the database MY_DB:
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SEMANTIC_TABLES
WHERE semantic_view_name = 'O_TPCH_SEMANTIC_VIEW'
AND semantic_view_database_name = 'MY_DB';
+-------------------+---------------------+------------------+----------------------+-------------------------+---------------------------+---------------------------+-----------------------------+------------------+----------+-------------------------------+-------------------------------+---------+---------+
| SEMANTIC_TABLE_ID | SEMANTIC_TABLE_NAME | SEMANTIC_VIEW_ID | SEMANTIC_VIEW_NAME | SEMANTIC_VIEW_SCHEMA_ID | SEMANTIC_VIEW_SCHEMA_NAME | SEMANTIC_VIEW_DATABASE_ID | SEMANTIC_VIEW_DATABASE_NAME | PRIMARY_KEYS | SYNONYMS | CREATED | LAST_ALTERED | DELETED | COMMENT |
|-------------------+---------------------+------------------+----------------------+-------------------------+---------------------------+---------------------------+-----------------------------+------------------+----------+-------------------------------+-------------------------------+---------+---------|
| 101 | LINEITEM | 49 | O_TPCH_SEMANTIC_VIEW | 92 | MY_SCHEMA | 7 | MY_DB | [ | NULL | 2025-02-28 16:16:04.363 -0800 | 2025-02-28 16:16:04.363 -0800 | NULL | NULL |
| | | | | | | | | "L_ORDERKEY", | | | | | |
| | | | | | | | | "L_LINENUMBER" | | | | | |
| | | | | | | | | ] | | | | | |
| 99 | CUSTOMER | 49 | O_TPCH_SEMANTIC_VIEW | 92 | MY_SCHEMA | 7 | MY_DB | [ | NULL | 2025-02-28 16:16:04.309 -0800 | 2025-02-28 16:16:04.309 -0800 | NULL | NULL |
| | | | | | | | | "C_CUSTKEY" | | | | | |
| | | | | | | | | ] | | | | | |
| 100 | ORDERS | 49 | O_TPCH_SEMANTIC_VIEW | 92 | MY_SCHEMA | 7 | MY_DB | [ | NULL | 2025-02-28 16:16:04.321 -0800 | 2025-02-28 16:16:04.321 -0800 | NULL | NULL |
| | | | | | | | | "O_ORDERKEY" | | | | | |
| | | | | | | | | ] | | | | | |
| 102 | SUPPLIER | 49 | O_TPCH_SEMANTIC_VIEW | 92 | MY_SCHEMA | 7 | MY_DB | [ | NULL | 2025-02-28 16:16:04.376 -0800 | 2025-02-28 16:16:04.376 -0800 | NULL | NULL |
| | | | | | | | | "S_SUPPKEY" | | | | | |
| | | | | | | | | ] | | | | | |
| 98 | NATION | 49 | O_TPCH_SEMANTIC_VIEW | 92 | MY_SCHEMA | 7 | MY_DB | [ | NULL | 2025-02-28 16:16:04.294 -0800 | 2025-02-28 16:16:04.294 -0800 | NULL | NULL |
| | | | | | | | | "N_NATIONKEY" | | | | | |
| | | | | | | | | ] | | | | | |
| 97 | REGION | 49 | O_TPCH_SEMANTIC_VIEW | 92 | MY_SCHEMA | 7 | MY_DB | [ | NULL | 2025-02-28 16:16:04.249 -0800 | 2025-02-28 16:16:04.249 -0800 | NULL | NULL |
| | | | | | | | | "R_REGIONKEY" | | | | | |
| | | | | | | | | ] | | | | | |
+-------------------+---------------------+------------------+----------------------+-------------------------+---------------------------+---------------------------+-----------------------------+------------------+----------+-------------------------------+-------------------------------+---------+---------+