How Does Fivetran Handle Column Header Updates?

Question

I want to update a column header in a file Fivetran has already synced. How will Fivetran handle the change?

Environment

File connectors

Answer

When you update a column header in a file we have already synced, we do the following:

1. Create a new column in your destination table reflecting the updated column header.
2. Copy the existing data from the old column to the new column.
3. Populate the new column with new data during subsequent syncs.
4. Retain the old column reflecting the outdated column header, adding null values during subsequent syncs.