Knowledge Drop

How do I make a static PDT?

  • 7 July 2021
  • 0 replies
  • 49 views

Userlevel 5
Badge
  • Looker Staff
  • 171 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!

Reply