Issue
What happens when there are changes to a table’s structure (e.g., new columns, changes in indexes, removal of columns)?
Environment
Databases
Resolution
We track DDL changes (Alters) in the database by running queries against the source to pull the columns and data types and comparing them to what we synced previously to identify any structural changes in the tables.