Hands-On Industrial Internet of Things

Advanced Stream Analytics

In the previous section, we discovered how Stream Analytics works. In this section, we are going to discuss some of the more advanced features of this service; in particular, the query language. The Query tab allowed us to define a simple, SQL-like query to process data and store it in data lake. This mechanism can also be applied to different storage mechanisms such as SQL, Event Hub, BLOB, Power BI, and Azure Functions. We can also link different input data sources, such as other data streams or reference data. Reference data is data that is statically stored, normally in a BLOB store, that can be joined with the input data stream. An example of reference data would be the asset information.

The Advanced Stream ...