Implementing Incremental Sync from PostgreSQL to S3

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

User is inquiring about implementing incremental sync from PostgreSQL to S3 using Change Data Capture (CDC) with a table that lacks a primary key but has REPLICA IDENTITY = full. Currently, only full refresh is available in sync mode.


Question

How can I implement incremental sync from PostgreSQL via CDC? I have a table without a primary key, but with REPLICA IDENTITY = full , and target is S3. And I have Full refresh only in Sync mode.


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['incremental-sync', 'postgresql', 'cdc', 's3', 'replica-identity', 'full-refresh']