CDC with Azure Data Factory - Change Data Capture on Azure - Basic Examples using DataFlows
In this video, we see how CDC works in Azure Data Factory and Azure SQL Database. By enabling CDC on the database and utilizing Azure Data Factory Data flows we perform an initial load from source to target, plus all the subsequent incremental changes.
A very common scenario is to load the data into Delta format creating a Data Lake. CDC takes care of this scenario as it has option to store the data into Delta format.
Follow me on social media:
LinkedIn: / apostolos-athanasiou-9a0baa119
GitHub: https://github.com/apostolos1927
00:00 - Intro
01:38 - CDC behind the scenes
03:08 - Enabling CDC on Azure SQL Database
05:12 - From source table to target table
11:50 - Multiple Source and Multiple Destinations
19:56 - Change Data Capture Preview