View the original community article here
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.