Knowledge Drop

How can I quickly test dev mode PDTs without generating the entire PDT?


Userlevel 3
Badge

Last tested: Sep 27, 2019
 

Working Faster in Development Mode (Docs)

There are cases when the PDT you're creating may take a long time to generate, which can be frustrating when testing lots of changes in development mode. Looker supports a conditional WHERE clause for development mode that helps manage this:

view: my_view {

derived_table: {

sql:

SELECT columns

FROM

my_table

WHERE

-- if prod -- date > '2000-01-01'

-- if dev -- date > '2015-01-01'

;;

}

}

 

Note: if no filtering is wanted in prod, you can do -- if prod -- 1=1, or you can put the WHERE inside the --if dev.

 

Link to full PDT Documentation (Docs).

 

This content is subject to limited support.                

 


0 replies

Be the first to reply!

Reply