SpecsModelExploreRequirements
SpecsModelExploreRequirements
CDC sync from production
Overview
Specification
Steps
IDingestion.cdc-sync
DescriptionReplicate operational DB changes to the lake in near real time.
Keycdc-sync
TypeSequence Workflow Diagram
Tags
ingestion
storage
Table of contents
  • Specification
  • CDC sync from production
  • Steps

Specification

CDC sync from production

Replicate operational DB changes to the lake in near real time.

End-to-end flow

This workflow is documented in specs under Workflows and embedded here as the canonical sequence diagram for the model.

Steps

Workflow steps
NumberSourceDestinationDescription
1Production DBCDC readerWAL/binlog connector to dest
2CDC readerPosition trackerPersist entities.LOG_POSITION
3CDC readerKafka publisherEmit services.CdcPublisher.PublishChange
4Kafka publisherEvent busPublish channels.cdc.public.publish
5Event busStream routerConsume:channels.cdc.public.subscribe via dest
6Stream routerData lakeWrite tables.bronze_cdc_orders schema subjects.cdcPublic.schema
Open diagram editor (read-only in guest)