Reference for Sequin’s CDC messages.
update
operations, contains the previous values of changed fields. For insert
and delete
operations, this field is null.insert
: A new row was createdupdate
: An existing row was modifieddelete
: A row was deletedread
: A row was read during a backfillmetadata
of each message includes an idempotency_key
which your application can use to reject any possible duplicate messages.
For regular changes (non-backfill), the idempotency key is based on the transaction’s position in the database log and its position within that transaction.
For backfill messages, the key is based on the backfill’s unique identifier and the primary key values of the record being processed.