How to enable change tracking on a Snowflake table
This guide explains how to enable change tracking on a Snowflake table. You will need to enable change tracking to use the table with Propel.
We will cover how to alter a table to enable change tracking and how to check if it is enabled.
You can learn more about Snowflake's change tracking in Snowflake's official documentation.
Requirements​
- You have a Snowflake account with data loaded in a table.
- You have a Snowflake user account with
OWNERSHIP
privilege for the table.
Step 1: Enable change tracking on a Snowflake table​
Enable change tracking on a Snowflake table by running the following SQL statement:
ALTER TABLE <table_name> SET CHANGE_TRACKING = TRUE;
You must run this statement with the role that is the owner of the table.
Step 2: Check if a Snowflake table has change tracking enabled​
To check if a table has change tracking enabled, use the following query:
SHOW TABLES LIKE '<table_name>';
This statement returns:
+--------------+----------------------+-----------------+---------------------+------------------------------+
| name | automatic_clustering | change_tracking | search_optimization | search_optimization_progress |
+--------------+----------------------+-----------------+---------------------+------------------------------+
| <table_name> | OFF | ON | OFF | |
+--------------+----------------------+-----------------+---------------------+------------------------------+
Then you can see if change_tracking
is ON
or OFF
.
Conclusion​
In this guide, you learned how to enable change tracking on a Snowflake table and how to check if a table has change tracking enabled.