Hey folks,
I’m facing an issue with AIRBYTE OSS ' column ordering while syncing from MySQL to Redshift.
In my MySQL source table, the column order is:
A, B, C, D
However:
In the Airbyte UI, columns appear in a different order (alphabetical)
In the Redshift destination table, the column order is again different (e.g., C, B, D, A)
Also, even if I manually create the table in Redshift with the correct column order and existing data, once I run an Airbyte sync, the column order gets changed again.
So effectively:
MySQL order ≠ Airbyte UI order ≠ Redshift order
My requirement is to have the exact same column order in the destination as the source, without doing any downstream transformations (views, CTAS, DBT models etc.).
Is there any way to configure Airbyte (connectors, normalization, etc.) to preserve column order exactly as in the source?
Or is this behavior inherent to how Airbyte handles schema and table creation?
KEY POINT TO NOTE: IM USING AIRBYTE OSS HOSTED ON AWS EKS
Thanks!