Hello, I am currently testing out Airbyte, specifically CDC replication on MSSQL. Could someone point me to the right direction on best practices to handle Schema changes (i.e ADD Columns, DROP Columns, ALTER Columns types)

@[DEPRECATED] Marcos Marx turned this message into Zendesk ticket 2837 to ensure timely resolution!

Hi! This is an excellent question. Let me look into and I'll get back to you in a bit!

So looks like there's an epic open for this, but it is not implemented yet: https://github.com/airbytehq/airbyte/issues/12089 I'll try to find out where this is on the roadmap, but cannot give you concrete dates right now. At this point if the schema changes, I believe you need to do a full reset - run a full refresh sync. This will result in the loss of historical data unfortunately. I'll research this further early next week and let you know if I find any other workarounds :)

So looks like there's an epic open for this, but it is not implemented yet: https://github.com/airbytehq/airbyte/issues/12089 I'll try to find out where this is on the roadmap, but cannot give you concrete dates right now. At this point if the schema changes, I believe you need to do a full reset - run a full refresh sync. This will result in the loss of historical data unfortunately. I'll research this further early next week and let you know if I find any other workarounds :)