cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Change Data Capture with Databricks

isaac_gritz
Valued Contributor II
Valued Contributor II

How to leverage Change Data Capture (CDC) from your databases to Databricks

Change Data Capture allows you to ingest and process only changed records from database systems to dramatically reduce data processing costs and enable real-time use cases such as real-time dashboards.

Here are the steps for how you can use CDC with Databricks:

  1. Leverage a Databricks CDC Partner tools like Fivetran, Arcion, Airbyte and more you can capture incremental changes from cloud and on-prem databases and ingest them into Delta Lake in real-time.
  2. From there you can leverage Delta Live Tables or a combination of Delta Lake, AutoLoader (AWS, Azure, GCP) and MERGE INTO (AWS, Azure, GCP) to automatically pick up these change data files as they land and process only the changed records in real-time.

Here is a Data & AI Summit talk from GetYourGuide about how they saved 70% on ETL costs by moving to a CDC architecture using Databricks and Debezium.

How has moving to a CDC architecture helped your organization? Let us know in the comments!

1 REPLY 1

prasad95
New Contributor II

Hi, @isaac_gritz can you provide any reference resource to achieve the AWS DynamoDB CDC to Delta Tables.
Thank You,

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.