Knowledge Drop

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

Userlevel 3

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: {


SELECT columns




-- 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!