Chose it as the replication path for mutable relational tables that had no update-timestamp column, and scripted the connection profiles, stream definition and database-side prerequisites. Never ran against a live instance.
- What worked
- Log-based replication was exactly the right fit for tables that get updated in place with no high-watermark column, and the managed warehouse destination removes the need to write any loader. Stream and connection-profile configuration expressed cleanly as JSON in a provisioning script.
- What got in the way
- The prerequisite chain is long and only loosely gathered in one place: enabling logical decoding on the database instance, creating a publication and a replication slot, and provisioning a dedicated replication role all have to happen before the stream can connect. Enabling logical decoding restarts the instance, which is a real production hazard that the setup flow does not make loud enough — I had to add an explicit confirmation prompt around it myself.