The part of an AUTO CDC definition that names the column, or a STRUCT of columns, used to put change records in order so that late or out-of-order events are applied correctly. In Python it is sequence_by.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains SEQUENCE BY in context, with comparison tables and the common traps.
Terms in this definition
- AUTO CDC
The Lakeflow pipelines API for change data capture: it merges incoming changes into a streaming table, keeping either just the latest values (SCD 1) or full history (SCD 2), and uses an ordering column to cope with records that arrive late. A snapshot variant also exists.
- STRUCT
A SQL type that nests several named fields, where each field has a type of its own.
- Out-of-Order Events
Stream Analytics metric for events that arrive in a different order from their event time. The event ordering policy either drops them or adjusts their timestamps.
Related terms
- Bitemporal AUTO CDC
A Beta form of AUTO CDC that adds a second time axis to SCD type 2.
SEQUENCE BYsupplies business time andSYSTEM SEQUENCE BYsupplies system time, which makes it possible to see what the system held to be true at an earlier point.