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

Question

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

Environment

Source databases and destinations.

Answer

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.