Knowledge Drop

How do I make a static PDT?

Userlevel 5
  • Looker Staff
  • 172 replies

Last tested; Jul 6, 2017

This is not recommended - if you have static values, they should be a non-persisted derived table or written to your database.

That said, you can use sql_trigger_value: SELECT 1 ;;. This value will never change so the PDT will never be rebuilt unless the SQL is changed or someone requests a manual rebuild.


This content is subject to limited support.                



0 replies

Be the first to reply!