Common query patterns

Many patterns can be used with Azure Stream Analytics, and it is impossible to include them all in this book. However, we will try to cover the most common ones and describe them in terms of syntax.

Multiple outputs

It is possible to read data from the same input and push it to multiple outputs at the same time, as illustrated in the following code snippet:

SELECT
     *
INTO
     Output1
FROM
     Input TIMESTAMP BY Time
SELECT
     Column1,
     Column2
INTO
     Output2
FROM
     Input TIMESTAMP BY Time
GROUP BY
     Column1

As you can see, that pattern is quite simple as it only requires you to put two SELECT statements in the same query. Azure Stream Analytics takes care of proper processing and distinguishing the streams.

Data aggregation over time

One of the most popular patterns...