Skip to main content
Advanced ~24 hours

Change Data Capture Pipeline with Debezium

Build a CDC pipeline: Postgres → Debezium → Kafka → Snowflake. The 2026 pattern for real-time analytics on transactional data.

DebeziumPostgreSQLKafkaSnowflake or BigQuery

About this project

CDC (Change Data Capture) is how modern data warehouses stay fresh — instead of nightly batch jobs, you stream every Postgres row change directly. This project teaches Debezium, Kafka Connect, and the dimensional-modeling adjustments needed for CDC-fed warehouses. Set up a small Postgres source, run Debezium, write changes to Kafka, and land them in Snowflake or BigQuery.

Why build this in 2026?

Real-time analytics needs CDC; engineers who have run it in production are hard to find.

What you'll ship

  • docker-compose stack
Architecture diagram
Writeup explaining CDC trade-offs

Sign up to see the full project brief

Full deliverables, success criteria, and AI Career Tutor support — free.

You'll unlock:Complete project brief, AI tutor that knows this project, and progress tracking when you start.

Skills you'll practice

postgresqlkafkasql