Change the sql_trigger_value parameter of user_facts toselect the current date plus one hour, so it triggers an hour after orders_rollup.

Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}

Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.

Change the orders_rollup view reference to the literal table name from the database’s scratch schema.