View the original community article here
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.