Makes downstream refreshes happen when upstream Delta data changes, for streaming tables and materialized views. Refreshes run at most once a minute unless AT MOST EVERY sets longer, and 10 sources is the limit.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains TRIGGER ON UPDATE in context, with comparison tables and the common traps.
Terms in this definition
- Streaming
Sending model output piece by piece as server-sent events. Only the delivery changes; the answer's content, completeness and cost stay the same.
- Once flow
A flow that executes a single time and repeats only if the pipeline is fully refreshed. It's a common choice for a first full load ahead of a change feed, and that refresh becomes dangerous once the original files no longer exist.
- LIMIT
Caps how many rows a SQL query gives back. Don't treat what you get as random or representative.