Postgres CDC: some tables have Incremental, others dont

What causes some tables to have Incremental Append as an option, and others not? Is this expected ?
On thing that I noted is that the tables where Incremental was not an option do not have primary keys, but I am not sure this is related.
The two prints are from the same connection.
(Postgres CDC → S3 Parquet connection)


  • Is this your first time deploying Airbyte: No / Yes
  • Deployment: Helm chart on Kubernetes
  • Airbyte Version: v0.35.62-alpha
  • Source name/version: Postgres
  • Destination name/version: S3

Hi @auyer,

Yes indeed, the source table needs to have a primary key to be loaded incrementally, because it’s using the table primary key for downstream duplication if Incremental - Deduped history is enabled.

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.