Why Doesn't the Source Column Order Match the Destination?

Question

I noticed that the column order in my data source is not preserved in the destination table. Is this expected, and can I configure the connection to reflect the source column order?

Environment

Connector: All

Destination: All

Answer

The column order in your destination tables is not guaranteed to match the order from any data source.

By default, Fivetran may write columns in alphabetical order or according to the schema definition at the time of table creation. New columns are appended at the end of the table.

This is expected behavior across all connector types, and there is currently no built-in configuration or workaround within Fivetran to preserve the original column order.

For downstream processing or display needs, we recommend referencing columns by name in your queries or transformations.

If a specific column order is required, you can create a view or transformation in your destination to reorder columns as needed for display or export purposes.