Change Data Capture with Databricks

[isaac_gritz]

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!

[prasad95]

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