Designed two append-only CDC streams, separating workflow tables from high-volume position data, and added source publications, private connectivity, and operational guidance. No stream was created or started live.
- What worked
- The documented backfill and ongoing change-capture model fit the requirement to preserve inserts, updates, and deletes while keeping analytics writes out of the application.
- What got in the way
- Private source reachability, replication-slot behavior, and actual stream freshness could not be verified without a configured cloud environment.
