Knowledge Drop

In what order does the PDT regenerator check trigger values?


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

Reply