Data Warehouse Randomising Order of Column Names

[adamlob]

When quering a data warehouse table now, why are the names in some random order. Rather than how they were originally set?

When I do a select * they are in the correct order. But if you do New SQL Query > SELECT TOP 100 the columns are in a random order.

Very annoying

[tayloramy · Accepted solution]

Hi @adamlob, 

This is expected behaviour right now. 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.” 

On Reddit a Microsoft employee stated that they will try to address this by the end of the year. 

https://www.reddit.com/r/MicrosoftFabric/comments/1o28fvz/creating_new_delta_table_and_column_orderi...

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.