Hi everyone
I'm still reading more on the docs to...
# ask-ail
Lucas Abreu
06/06/2023, 8:07 PMHi everyone
I'm still reading more on the docs to know if AirByte suits our needs, so sorry if any question is really newbie. Also Posting here as I'm not aware a better channel.
Reading the doc using Postgres CDC, it states that once a schema change is made in the source database, one needs to restart the sync. Questions:
• By sync restart: does Airbyte start the replication from zero ? I.e. another consistent snapshot from the databsae ? If it does start from scratch, do we have benchmark on latency ?
• Am I able to restart only the schema modified table or is that connection level, i.e., apply to all tables in the connection ?
k
kapa.ai
06/06/2023, 8:07 PMA message from kapa.ai
kapa.ai
06/06/2023, 8:09 PMHi! No worries, I'm here to help with your questions about Airbyte and Postgres CDC. 1. When a schema change is made in the source database, Airbyte does not support automatic schema changes for CDC sources. You'll need to reset and resync the data if you make a schema change [source](https://docs.airbyte.com/integrations/sources/postgres#cdc-considerations). This means that you'll need to perform a full refresh of the affected table(s). The latency of this process depends on the size of your data and your specific setup. 2. For the Postgres connector, you can reset a single table within the connection without resetting the rest of the destination tables in that connection [source](https://airbytehq.slack.com/archives/C021JANJ6TY/p1674231762419599). However, you'll need to refresh the source schema and update the connection configuration to capture the new fields [source](https://airbytehq.slack.com/archives/C021JANJ6TY/p1675703730453619). I hope this helps! If you have more questions, feel free to ask.