Querying data using theAzure Stream Analytics query language
The strength of Azure Stream Analytics—besides the rich selection of Azure services that seamlessly integrate with it—lies in its query language, which allows you to analyze an input stream easily and output it to a required service. As it is a SQL-like language, it should be intuitive and easy to learn for most developers using this service. Even if you are not familiar with SQL, the many examples available and its simple syntax should make it easy for you.
Writing a query
In the Azure portal, the query window for Azure Stream Analytics can be found either in the Overview or Query blade. It looks like this:
Figure 14.9 – The Query window in the Overview blade
In the preceding example, you can see a simple SQL-like query that performs the following three actions:
- Selects data from the input using the given alias
- Chooses...