Data Warehouse Randomising Order of Column Names

Question

When quering a data warehouse table now, why are the names in some random order. Rather than how they were originally set?&nbsp;When I do a select * they are in the correct order. But if you do New SQL Query &gt; SELECT TOP 100 the columns are in a random order.&nbsp;Very annoying

tayloramy · Accepted Answer

Hi&nbsp;adamlob,&nbsp;&nbsp;This is expected behaviour right now.&nbsp;The UI builds an explicit column list using a metadata view that isn’t guaranteed to preserve creation order, so the column list can look “random.”&nbsp;&nbsp;On Reddit a Microsoft employee stated that they will try to address this by the end of the year.&nbsp;https://www.reddit.com/r/MicrosoftFabric/comments/1o28fvz/creating_new_delta_table_and_column_ordering_in/&nbsp;If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Forum Discussion

Related content

Warehouse Scaling

Data Warehouse Drop Column

warehouse vs lakehouse

Warehouse CICD

SQL Server Agent in Fabric Warehouse