Data platform · Platform Concepts

What is CDC?

MediumCDCDebeziumOLTPstreaming

Interview question

What is Change Data Capture (CDC)?

How to answer

The short answer

streams database changes (inserts/updates/deletes) from systems into downstream systems, often via the database transaction log.

Output
Postgres WAL -> Debezium -> Kafka -> warehouse / search / cache

Why CDC beats nightly full dumps

  • Lower latency
  • Less load than repeatedly scanning whole tables
  • Captures deletes and updates
  • Preserves change order (with care)

Tiny example

An orders row status flips placed → shipped. CDC emits an update event; the warehouse merges it into orders_current and maybe appends to orders_history.

Caveats

Schema changes, tombstones/deletes, initial snapshots, and exactly-once merges into sinks all need design.

Interview tip: "CDC reads the transaction log to emit row-level changes." Name a tool chain ( + Kafka) if you know one.