Is there a way that Looker will not put order by in SQL and just in visulization?

  • 11 July 2017
  • 1 reply

Userlevel 2

Need to see if is there a option to avoid order by in SQL but in display it still have it. Reason is, we have 6 looks on the dashboard with same dimensions and measures, only different is order by field. Becasu of order by field only Looker run 6 queries in place of one, which is affecting performacne of the dashbaord. If somehow we can remove order by from teh SQL then the sql for all 6 looks will be the same and it will run only one SQL. Is it makes sense 🙂

1 reply

Hi @kshah7!

At this moment all Looker generated queries contain an order by clause in the SQL so that we know how to order them on the front end. There is currently no way to order them on the front end without using order by clause in the SQL but I will make sure pass on your feedback to the product team. Please let us know if you have any further questions.