Sorting on SQL Data Explorer Tables does not work. Integers are treated as strings

When I use the sort directly in the tables, this treats everything as a string. In the provided example, I count the number of registered events per month per user. In the query, they are defined as integers, and I order by such and they populate correctly. As soon as I sort from the table headers, everything gets sorted as a string. This means that if I want to browse my recently made query and sort by another field, I have to rerun the whole query since I can’t do it from the already generated table. This is extremely inneficient as the only other workaround is to download the output as a csv, but i don’t want to do that every time when I’m verifying outputs.

Hi Richard,

Thanks for reporting this. I have reproduced it and validated that this is indeed a bug.
I have logged this internally for the team to take a look at.

Thanks.