Best Software for 2025 is now live!
View the Winners
  1. Home
  2. ...
  3. Data Warehouse Solutions
  4. Snowflake
  5. Snowflake Discussions
  6. What's the best way to manage change data capture in Snowflake?
Samuel S.
SS
Architect by day | Gamer by night
Expand/Collapse Social Share Options

What's the best way to manage change data capture in Snowflake?

Since Snowflake doesn't enforce constraints, what are the best practices to ensure incremental loads while maintaining data integrity?
4 comments
Looks like you’re not logged in.
Users need to be logged in to answer questions
Log In
Veera T.
VT
Search Engine Optimization Executive at hkr
0
You might get a relevant answer from it.
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Anita B.
AB
0
Hello, Good Afternoon! Please go through this link: https://docs.snowflake.com/en/user-guide/streams.html It might give you a relevant answer. If anyone to learn Snowflake Online Training, then please go through this link: https://mindmajix.com/snowflake-training Thanks & Regards, Anita
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Melinda W.
MW
Data Platform Architect
0
If you are trying to identify what changes happen in Snowflake tables you can use Snowflake streams as a stream keeps track of inserts, updates and deletes and you can have different ELT processes for each type.
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Stuart H.
SH
Head of Data & Analytics @ OSN
0
It in the upstream source system using something like AWS DMS.
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Already have Snowflake?

About Snowflake

Snowflake makes enterprise AI easy, efficient and trusted. Thousands of companies around the globe, including hundreds of the world’s largest, use Snowflake’s AI Data Cloud to share data, build applic
Discover More