Destination Improvement: Column Ordering
If source has created a table and when we query the table, the column ordering is like below
id, year, month, day, ..........
but when we query the same table in Destination/Snowflake, id and DATE columns are not displaying in the first.
Can you please implement the column ordering in destination as same as source or customer ordering?
-
Official comment
Hi all,
Thanks for your comments on this thread -- while we don't have a timeline for this feature request, please continue to share your feedback here so we can follow up on this feature.
I will be sure to share this feedback with our internal team for discussion!
-
Hi Can you please look into it and update if this is possible and can be doen soon?
-
I want to upvote this feature. We are adding a table with over 600 columns. It's going to make the table a lot more usable if I could rely on order being preserved in this case. Creating a custom view that reorders the columns back to the original form will also take a while since all column names have been auto-adjusted. An option to preserve order would be very helpful.
-
I am replicating hundreds, if not thousands, of tables. It would be extremely beneficial for end users for Fivetran to apply the same column ordering in the destination as found in the source.
-
Agree. For ERP's with hundreds of columns per table, not guaranteeing column order is a substantial dis-satisfier. Default functionality should guarantee column order per the data source. If schema change occurs in a data source, one that effects column order in a table, except to the extent that the destination (in our case Snowflake), prevents it.
-
Agree, this creates double work for us and unnecessary steps in the setup to re-create the correct order.
-
Completely agree, not maintaining ordinal position is a bug and should be dealt with quickly.
There are at least two other community posts about this:
- https://support.fivetran.com/hc/en-us/community/posts/1500000891061-Other-Please-make-the-column-ordinal-positioning-in-Destination-after-FIVETRAN-sync-match-with-the-Source-Database-column-ordinal-positioning-
- https://support.fivetran.com/hc/en-us/community/posts/4420223223831-Other-Handling-ordinal-postition-on-pipelines-between-RDBMS
Please sign in to leave a comment.
Comments
7 comments