> ## Documentation Index
> Fetch the complete documentation index at: https://www.propeldata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Change tracking on Snowflake tables

> How to enable change tracking on Snowflake tables

<div />

This guide covers how to:

1. Enable change tracking on a Snowflake table
2. Check if a Snowflake table has change tracking enabled

***

## Requirements

* You have a Snowflake account with data loaded in a table.
* You have a Snowflake user account with `OWNERSHIP` privilege for the table.

***

<Steps>
  <Step title="Enable change tracking on a Snowflake table">
    Enable change tracking on a Snowflake table by running the following SQL statement:

    ```sql theme={"system"}
    ALTER TABLE <table_name> SET CHANGE_TRACKING = TRUE;
    ```

    You must run this statement with the role that is the owner of the table.
  </Step>

  <Step title="Check if a Snowflake table has change tracking enabled">
    To check if a table has change tracking enabled, use the following query:

    ```sql theme={"system"}
    SHOW TABLES LIKE '<table_name>';
    ```

    This statement returns:

    ```sql theme={"system"}
    +--------------+----------------------+-----------------+---------------------+------------------------------+
    |   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`.
  </Step>
</Steps>