improve performance in looker derived table

  • 21 January 2022
  • 1 reply
  • 49 views

I have a question about how to improve query performance in looker. I use derived table in looker to transform data. In the sql code for derived table, I use cte, a lot of case statement and join etc. but the query performance is not good. Since I use bigquery as data warehouse and connected to looker, will it improve the performance if I transform data in bigquery and then load into looker? In addition, how to improve the query performance when it has lots of case statements in sql code for the derived table? Will PDT helpful? 


This topic has been closed for comments

1 reply

Userlevel 5
Badge

If you don’t have any liquid filters in your derived table and it’s fine to have some lag in the data then PDT is the most helpful solution most likely.