Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Azure Stream Analytics
open-in-new
<h2 id="query-language">Query Language</h2> <p>Users can author real-time analytics using a simple declarative <a href="/facts/SQL/UjQLJcYm">SQL</a>-like language with embedded support for temporal logic. Callouts to custom code with <a href="/facts/JavaScript/XhhIIEsl">JavaScript</a> user defined functions extend the streaming logic written in SQL.<a class="footnote-ref" id="fnref:3" href="#fn:3"><sup>3</sup></a> Callouts to <a href="/facts/Microsoft_Azure/CCnIHTHd"> Azure Machine Learning</a> helps with predictive scoring on streaming data. </p> <h2 id="scalability">Scalability</h2> <p>Azure Stream Analytics is a serverless job service on Azure that eliminates the need for infrastructure, servers, virtual machines, or managed clusters. Users only pay for the processing used for the running jobs.<a class="footnote-ref" id="fnref:4" href="#fn:4"><sup>4</sup></a> </p> <h2 id="iot-applications">IoT applications</h2> <p>Azure Stream Analytics integrates with <a href="/facts/Microsoft_Azure/CCnIHTHd">Azure IoT Hub</a> to enable real-time analytics on data from <a href="/facts/Internet_of_things/rwwGAxn3">IoT</a> devices and applications.<a class="footnote-ref" id="fnref:5" href="#fn:5"><sup>5</sup></a> </p> <h2 id="real-time-dashboards">Real-time Dashboards</h2> <p>Users can build real-time dashboards with <a href="/facts/Power_BI/xqJUmU2w">Power BI</a> for a live command and control view. Real-time dashboards help transform live data into actionable and insightful visuals. </p> <h2 id="data-input-sources">Data Input Sources</h2> <p>Stream Analytics supports three different types of input sources - <a href="/facts/Microsoft_Azure/CCnIHTHd">Azure Event Hubs</a>, Azure IoT Hubs, and <a href="/facts/Microsoft_Azure/CCnIHTHd">Azure Blob Storage</a>.<a class="footnote-ref" id="fnref:6" href="#fn:6"><sup>6</sup></a> Additionally, stream analytics supports Azure Blob storage as the input reference data to help augment fast moving event data streams with static data.<a class="footnote-ref" id="fnref:7" href="#fn:7"><sup>7</sup></a> </p><p>Stream analytics supports a wide variety of output targets. Support for Power BI allows for real-time dashboarding.<a class="footnote-ref" id="fnref:8" href="#fn:8"><sup>8</sup></a> Event Hub, Service bus topics and queues help trigger downstream workflows. Support for Azure Table Storage, Azure SQL Databases, <a href="/facts/Microsoft_Azure/CCnIHTHd">Azure SQL Data Warehouse</a>, Azure SQL, <a href="/facts/Cosmos_DB/rCAusDul">Document DB</a>, <a href="/facts/Azure_Data_Lake/wvgb81f1">Azure Data Lake</a> Store enable a variety of downstream analysis and archiving capabilities.<a class="footnote-ref" id="fnref:9" href="#fn:9"><sup>9</sup></a> </p> <h2 id="external-links">External links</h2> <ul><li><a href="https://azure.microsoft.com/en-us/services/stream-analytics/">Official website</a></li></ul> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>JennieHubbard. "Introduction to Stream Analytics". docs.microsoft.com. Retrieved 2017-08-22. <a href="https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-introduction#key-capabilities-and-benefits" target="_blank">https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-introduction#key-capabilities-and-benefits</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>"Microsoft Azure Stream Analytics - Simple Talk". Simple Talk. 2015-06-02. Retrieved 2017-08-22. <a href="https://www.simple-talk.com/cloud/cloud-data/microsoft-azure-stream-analytics/" target="_blank">https://www.simple-talk.com/cloud/cloud-data/microsoft-azure-stream-analytics/</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> <li id="fn:3"><p>"Stream Analytics Query Language Reference". msdn.microsoft.com. Retrieved 2017-08-22. <a href="https://msdn.microsoft.com/library/dn834998.aspx#In%20this%20section" target="_blank">https://msdn.microsoft.com/library/dn834998.aspx#In%20this%20section</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li> <li id="fn:4"><p>JennieHubbard. "Introduction to Stream Analytics". docs.microsoft.com. Retrieved 2017-08-22. <a href="https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-introduction#key-capabilities-and-benefits" target="_blank">https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-introduction#key-capabilities-and-benefits</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li> <li id="fn:5"><p>"Stream Analytics Query Language Reference". msdn.microsoft.com. Retrieved 2017-08-22. <a href="https://msdn.microsoft.com/library/dn834998.aspx#In%20this%20section" target="_blank">https://msdn.microsoft.com/library/dn834998.aspx#In%20this%20section</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li> <li id="fn:6"><p>"Microsoft Azure Stream Analytics - Simple Talk". Simple Talk. 2015-06-02. Retrieved 2017-08-22. <a href="https://www.simple-talk.com/cloud/cloud-data/microsoft-azure-stream-analytics/" target="_blank">https://www.simple-talk.com/cloud/cloud-data/microsoft-azure-stream-analytics/</a> <a href="#fnref:6" class="footnote-back-ref">↩</a></p></li> <li id="fn:7"><p>"Microsoft Azure Stream Analytics - Simple Talk". Simple Talk. 2015-06-02. Retrieved 2017-08-22. <a href="https://www.simple-talk.com/cloud/cloud-data/microsoft-azure-stream-analytics/" target="_blank">https://www.simple-talk.com/cloud/cloud-data/microsoft-azure-stream-analytics/</a> <a href="#fnref:7" class="footnote-back-ref">↩</a></p></li> <li id="fn:8"><p>"Stream Analytics Query Language Reference". msdn.microsoft.com. Retrieved 2017-08-22. <a href="https://msdn.microsoft.com/library/dn834998.aspx#In%20this%20section" target="_blank">https://msdn.microsoft.com/library/dn834998.aspx#In%20this%20section</a> <a href="#fnref:8" class="footnote-back-ref">↩</a></p></li> <li id="fn:9"><p>"Stream Analytics Query Language Reference". msdn.microsoft.com. Retrieved 2017-08-22. <a href="https://msdn.microsoft.com/library/dn834998.aspx#In%20this%20section" target="_blank">https://msdn.microsoft.com/library/dn834998.aspx#In%20this%20section</a> <a href="#fnref:9" class="footnote-back-ref">↩</a></p></li> </ol>