Skip to main content
Mati Data, home

Build a CDC pipeline, step by step

The order I build a change data capture pipeline in, each step linked to the file in my public repositories that shows it done.

The decision it helps with

Where to start, and in what order, when a pipeline has to keep an analytics warehouse in step with a transactional database.

How to use it

  1. Work through the phases in order; each one rests on the one before it.
  2. Open the linked files to see a step done in a pipeline that runs, then adapt it to your own sources.
  3. Tick a step only when something checks it: a test, a query or an alert, not a belief.
  4. To see every phase running before you build your own, clone the cdc-starter template and run make demo.

The steps

Requirements first
Source and ingestion
Change capture
Landing in the warehouse
Models and tests
Observability
Orchestration and CI
Document it

Free to use and adapt under the Creative Commons Attribution licence: credit Matiwos Desalegn and link to this page.