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.