Question

Moving Unnest Statements to the end of the query

  • 7 June 2021
  • 0 replies
  • 88 views

When we use unnest query to flatten arrays in looker, by default the joins are added in the same order of the joins. The same is difficult when we extend the explores to re-use the joins. The unnest statements get added in the order of joins to the parent explore data. 

 

Is there anyway we can automate the process of automatically moving all the unnest statements that cannot be used with the cross join to the bottom of the SQL query as they are generated on the fly and creating derived tables and explores would make the process more complicated?


This topic has been closed for comments