Why a Column Deleted in the Source Is Still Present in the Destinationlink

Updated 12 days ago

Questionlink

I deleted a column in my source database, but I can still see it in the destination table?

Environmentlink

Source databases and destinations.

Answerlink

Fivetran keeps the columns that were deleted from the source untouched in your destination. Once you have deleted a column from the source, the corresponding column in the destination keeps whatever data it had before the deletion, and Fivetran writes null as the column's value from the deletion moment on.

For more details, see our Schema migration documentation.