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

Knowledge Drop

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.                

Version history
Last update:
‎05-07-2021 09:48 AM
Updated by: