cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
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 III

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

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!