# Change Data Capture (CDC)

> It copies each change in a database right as it is made.

**Field:** Data Engineering  
**Category:** Ingestion & Streaming  
**Also known as:** CDC, Log-Based CDC

## Think of it like

It is like a nosy friend who writes down every change you make to your room. You never have to say what changed.

## Definition

Change data capture copies each change in a database as it happens. It reads the database's own change log. Every insert, update and delete is written there. Each change becomes an event that is sent on to other systems. So a warehouse or a search index stays in step within seconds. The source database barely notices.

## Example

A bank uses CDC on its accounts table. Each balance change reaches the fraud system in about two seconds.

## Why it matters

It catches every update and every delete. A nightly copy misses those. It also puts little load on the app's database.

## Common mistake

Polling the table with a query for new rows. That misses deletes and rows changed twice between polls.

## Three principles

- **Read the log.** Use the database's own change log.
- **Every change.** Inserts, updates and deletes.
- **Low load.** The app's database barely notices.

## Related terms

- [Debezium](https://learn.benibix.com/term/data/debezium)
- [Data Ingestion](https://learn.benibix.com/term/data/data-ingestion)
- [Event Streaming](https://learn.benibix.com/term/data/event-streaming)
- [Database Replication](https://learn.benibix.com/term/development/database-replication)

## Told apart from

- [Change Data Capture vs Incremental Load](https://learn.benibix.com/compare/change-data-capture-vs-incremental-load): People think asking a table for rows with a newer time is CDC. That is an incremental load. It asks the table on a timer and only sees rows as they are now. CDC reads the database's change log, so it catches every change, deletes too, within seconds.

![An app writes to its database. The database writes each change to its log. A CDC tool reads the log and sends each change as an event to a stream, which feeds a warehouse and a search index.](https://learn.benibix.com/diagrams/change-data-capture.svg)

---

Source: https://learn.benibix.com/term/data/change-data-capture
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
