snowflake-cloud-data-platform - 如何检查雪花表是否启用了 CHANGE_TRACKING？

Question

我正在尝试验证是否为 Snowflake 表启用了 CHANGE_TRACKING。 Information_Schema 中是否提供此信息？

Answer 1

据我所知，它在information_schema中不可用，但您可以查看SHOW TABLES命令的change_tracking列:

show tables like 'employees';

+-----------+----------------------+-----------------+---------------------+------------------------------+
|   name    | automatic_clustering | change_tracking | search_optimization | search_optimization_progress |
+-----------+----------------------+-----------------+---------------------+------------------------------+
| EMPLOYEES | OFF                  | ON              | OFF                 |                              |
+-----------+----------------------+-----------------+---------------------+------------------------------+

显示表格 https://docs.snowflake.com/en/sql-reference/sql/show-tables.html

您可以使用 result_Scan 函数来处理 SHOW TABLES 命令的输出。

RESULT_SCAN https://docs.snowflake.com/en/sql-reference/functions/result_scan.html