Question

Regenerating Persistent Derived Tables

  • 3 January 2015
  • 0 replies
  • 68 views

Userlevel 4

A full list of the behaviors for how the PDTs regenerate themselves:



  • Whenever they hit their trigger they will regenerate.

  • Whenever the SQL has changed either from being edited or pushed, the PDTs regenerate at the next query run.

  • The PDTs associated with the query will all regenerate when selecting rebuild derived tables from the gear menu in Explore.

  • Finally, we are working on a regenerate all PDTs feature, it is on our roadmap, in the meanwhile you could try dropping and recreating the looker_scratch schema as a workaround if it is easy to do.


For more on PDTs, read our documentation here.


0 replies

Be the first to reply!

Reply