# 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?

##### Post Metadata
- Posted at: over 6 years ago
- Author title: Architect by day | Gamer by night
- Net upvotes: 2


## Comments
### Comment 1


Please go through this link: https://docs.snowflake.com/en/user-guide/streams

You might get a pertinent response from it.

Please click on this link to learn more about Snowflake Online Training: 

https://hkrtrainings.com/snowflake-training


##### Comment Metadata
- Posted at: over 3 years ago
- Author title: Search Engine Optimization Executive at hkr



### Comment 2

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

##### Comment Metadata
- Posted at: over 5 years ago



### Comment 3

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.

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Data Platform Architect



### Comment 4

Do. It in the upstream source system using. Somethjng like aws DMS

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Head of Data & Analytics @ OSN




## Related Product
[Snowflake](https://www.g2.com/products/snowflake/reviews)

## Related Category
[Data Warehouse](https://www.g2.com/categories/data-warehouse)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4