We have Oracle source and Snowflake as target.
DDL changes are applied to the Oracle Source for monthly releases.
We have noticed that the DDL changes are not migrated to snowflake in several occasions and the behavior is very inconsistent.
In the most recent release, the following DDL changes on Source Oracle have not been migrated to snowflake when the CDC task resumed.
- Add Column
- Modify PK
- Add Partition and Localize Index
- Modify Nullability
Please provide resolution for this issue to have DDL changes automictically migrate without intervention (intervention in most cases required reload target tables to capture DDL changes.)
thank you so much.