Creating Windowed Aggregates
Windowed aggregates are essential for processing time series data, which is simply data recorded continuously over time. Examples of time series data could include stock prices recorded over time and IoT sensor values, which show the health of machinery over time.
Note
This section primarily focuses on the Create windowed aggregates concept of the DP-203: Data Engineering on Microsoft Azure exam.
In the subsequent sections, you’ll explore the different windowed aggregates that are available in ASA. ASA supports the following five types of windows:
- Tumbling Windows: These are fixed-size, non-overlapping windows where each window covers a specific time duration, and data is aggregated separately for each window.
- Hopping windows: Similar to Tumbling Windows, hopping windows also have a fixed size, but they can overlap with each other. This allows more flexibility in capturing data and analyzing trends over time.
- Sliding windows...
