Learn how to build reliable Postgres change data capture pipelines with Sequin. From idempotent processing, to schema transformations, to error handling.
Select the source
Select the message type
Leave message grouping default
Specify backfill
backfill
.action
of read
.Configure sink-specific settings
ON CONFLICT
clauses to handle duplicate messages safely. Most likely, your destination table will have the same primary key(s) as your source table. Make sure to include the primary key(s) in your ON CONFLICT
clause. That will ensure that writes to the destination table are idempotent.