Pre-requisite Before going through SCD Type 2, I would suggest visiting my earlier post with respective to SCD Type 1 in here for better understanding of this blog. Dynamic Merge in Snowflake using Stored Procedure and Python – For SCD Type 1 / Blogs / Perficient SCD Type 2 It helps in tracking the history […]
Vignesh Vangapalayam Chidambaram
Vignesh works at Perficient as Technical Architect. He has experience in technologies like Informatica PowerCenter, Databricks, Spark, AWS, and Snowflake. He is keen to learn new technologies.
Blogs from this Author
Dynamic Merge in Snowflake using Stored Procedure and Python – For SCD Type 1
Creating Snowflake Account We can create a 30-day free trial account using below link. https://signup.snowflake.com/ SCD Type 1 In short, keeps the latest the latest data only and old data is overwritten. SCD Type 1 in Snowflake Let us consider we have a scenario to load the data into Target table from the Source table. […]