Skip to main content

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.

  1. Enable change tracking on a Snowflake table
  2. Check if a Snowflake table has change tracking 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> 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.