Snowflake Change Tracking to implement SCD2
12:48 09 Jan 2024

Has anyone used change tracking feature in Snowflake to track DML changes on a table and create SCD2 tables in a Snowflake data warehouse? Not talking about using streams and tasks but specifically turning on change tracking on the table and using a stored procedure/ SQL to create SCD2 tables.

Link to documentation : https://docs.snowflake.com/en/sql-reference/constructs/changes

It looks like a possible way to implement scd2 but want to know if anybody has implemented it already. Also, when the feature was introduced and if it is stable.

snowflake-cloud-data-platform data-warehouse scd2