Designed managed change-data-capture from the operational relational database into the warehouse for three tables, in append-only mode so historical state transitions are preserved, with one high-volume table deliberately excluded. Configuration scripts were written and syntax-checked but never run.
- What worked
- Fully managed CDC with table-level selection meant no exporter service to build or operate, and the append-only write mode preserves status history that exists nowhere else in the system — the merge mode would have silently destroyed it. The choice between the two modes is consequential and the distinction was clear enough to get right.
- What got in the way
- The replication metadata column names have varied across versions, so every read of them had to be isolated into a single module with a written warning to fix it on first run. That version drift is the single biggest source of uncertainty in the whole delivery and is not well signposted.
