How are Alters Handled in Fivetran
Issue
What happens when there are changes to a table's structure, such as addition or removal of columns and changes in indexes?
Environment
Database Connectors
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.