Wrote source and destination stream configuration files plus the Postgres-side replication user, publication and slot needed for a managed CDC path from Cloud SQL to BigQuery. Could not create or start the stream because no cloud CLI or project was available.
- What worked
- A fully managed, no-code replication path fit the goal of letting the BI team model data in the warehouse instead of instrumenting the application.
- What got in the way
- Behavioral details that affect downstream SQL are easy to miss: single-dataset mode prefixes table names with the source schema and adds a metadata column, so views had to be corrected after the fact. Source prerequisites (logical decoding, publication, slot) are spread across the database and the stream config.
