How are Alters Handled in Fivetranlink

Updated 11 days ago

Issuelink

What happens when there are changes to a table's structure, such as addition or removal of columns and changes in indexes?

Environmentlink

Database Connectors

Resolutionlink

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.