Snowflake Streams: How to Implement Change Data Capture (CDC) in Snowflake

[@Sweety_24]

How will it work with millions of rows? You've only inserted two records, and it's working fine, but how will it perform with millions of rows?

[@varsharaj6492]

So Updating a record alone basically follows SCD 2 in a stream by preserving the history ???

[@SleekData]

Dude You have to get change data from the stream, then use it in the merge - please refer below links for more details... www.snowflake.com/blog/building-a-type-2-slowly-changing-dimension-in-snowflake-using-streams-and-tasks-part-1/ www.snowflake.com/blog/building-a-type-2-slowly-changing-dimension-in-snowflake-using-streams-and-tasks-part-2/