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
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.
