ELT & CDC offering supports the following schema changes without interruption on the pipeline:
- Column addition
- The column will automatically be added to the replication.
- Column deletion
- The column will not be removed in the destination and instead will have null values on new records. If you would like the column to be removed in the destination, then a resync for the table would be required.
The following schema changes will cause the pipeline to stop and will require a resync for tables that have any of the below changes. Please contact our support team to request a resync.
- Column rename
- Column data type change