Does Fivetran Add Columns in the Same Order As the Source?

Question

While adding a new column to the table in the destination, does Fivetran keep the same order as the source table or insert the new column after the last column?

Environment

Destinations

Answer

Fivetran always adds new columns at the end of the table and does not follow the same sequence as in the source.