Cant imagine that there is not already a solution or a Workaruond but if yout got something that works .. i will love it.
Ill hope you understand that there is everything fine with the query. The problem is caused by the editor that loads all the files instead of the first 1000 Rows and does that all the time at every step instead of one time and than show "This preview can be around 30 day old .." - dont matters for me, only want to work on the query and refresh if i am ready. Then there is no problem with 10 minutes of loading Data ..