Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
✅ Azure Stream Analytics ✅ Fabric Eventstream
Note
Fabric Eventstream is built on the same runtime as Azure Stream Analytics. Therefore, the concepts explained in this article are applicable to both Azure Stream Analytics and the Fabric Eventstream.
Query language extends SQL syntax to enable complex computations over streams of events. Stream Analytics provides language constructs to deal with the temporal aspects of the data. For example, it's possible to assign custom timestamps to the stream events, specify time window for aggregations, specify allowed time difference between two streams of data for JOIN operation, etc.
All time handling operations are in UTC.
| Item | Summary |
|---|---|
| System.Timestamp() | System.Timestamp() is a system property that can be used to retrieve the event’s timestamp. |
| TIMESTAMP BY | The TIMESTAMP BY clause allows specifying custom timestamp values. |
| Time Skew Policies | Policies for Out of Order and Late Arrival Events. |
| Aggregate functions over time window | Aggregate functions are used to perform a calculation on a set of values from a time window and return a single value. |
| DATEDIFF in JOIN predicate | Specify time boundaries for JOIN operations |
| Date and Time functions | Stream Analytics provides various date and time functions for use. |
See Also
Built-in Functions
Data Types
Event Delivery Guarantees(Azure Stream Analytics)