There is no fixed or documented โwindowโ time for the interval between updates to all monitored tables before a job with an "All tables updated" trigger runs in Databricks. The job is triggered as soon as every table in the set has seen at least one update since the last successful runโregardless of how much time has elapsed between the individual table updates.โ
Timing Behavior
-
If Table 1 is updated at 07:20 UTC, Table 2 at 16:48 UTC, and Table 3 at 16:50 UTC, the trigger waits for the last table in that set to be updated; the job will run after Table 3's update, even though there is a ~10 hour gap between Table 1 and Table 3.โ
-
There is no apparent reset or expiration windowโDatabricks tracks updates on all monitored tables since the last job run, and as soon as every table has received an update, the trigger fires.โ
Advanced Timing Options
-
You can optionally set โMinimum time between triggersโ (enforces a cooldown between runs irrespective of update activity) and โWait after last changeโ (holds off execution for a set period after the most recent update in case additional batch updates occur).โ
-
If both are set, Databricks waits for both timers to expire before firing the trigger.โ
Practical Implication
-
If one table updates hours before others, the job will only trigger once all tables have been updated, even if this takes many hours.โ