How Does Fivetran Handle Alters?
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 data definition language (DDL) changes, or 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.