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.