How to avoid order by in Look SQL?


I am using Looker with Google BigQuery and sometime reports are slow or throws resource exceed error due to order by clause. I also see post in discourse that suggests not to use order by for Google BigQuery SQLs but looker by default have order by clause and not able to find option to have order by optional to improve performance.

(molly.lippsett) #2

Hi @kshah7,

Currently, the option to remove table sorting in Looker is only for downloads. You’ll see the checkbox in the download modal. All other queries will have an ORDER BY clause in SQL.
If you’d like to tell me a little more about your use case, I’d be happy to pass your feedback on to our product team!