Schema change issue

Connector Questions & Issues
, ,
1

Hi Team,

I am working on building a CDC replication from PostgreSQL to BigQuery using Airbyte.
While testing I added a new column to see if Airbyte takes up the new column using the Incremental | Deduped + history mode.After following the steps listed in the ticket :
How does Airbyte handle replication when a data source changes its schema?

It shows up the new column in the BigQuery destination.
But now while I am trying to update the values of this new column in the Postgres source database
it gives an error:
ERROR: cannot update table "airbyte_tableXX" because it does not have a replica identity and publishes updates

HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.

Did it alter the table structure in the backend.If so, how can we avoid it?
Even the airbyte connection now does not show the Incremental modes, It is just showing the Full Refresh mode.

How can I fix this error?

3

Hey @harshita,
I’m under the impression that this error is not related to CDC or schema evolution.
I think the problem is that this table is replicated but might miss a primary key.
Feel free to check this stack overflow and let me know if it helps.

4

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.