Knowledge Drop

In what order does the PDT regenerator check trigger values?

Userlevel 5
  • Looker Staff
  • 173 replies

Last tested: April 2021


The regenerator checks PDT triggers in a completely arbitrary order. The only rule is that if there are table dependencies, then the regenerator will check in order of those dependencies.

What's a dependency?

If Table A references Table B in its SQL, then we call that a dependency. For example:

view: table_A { derived_table { sql: SELECT * FROM ${table_B.SQL_TABLE_NAME} ;;

This content is subject to limited support.                




0 replies

Be the first to reply!