Query Pattern of the Week: Use expressions inside a TIMESTAMP BY clause

Azure Stream Analytics allows expressing complex event processing rules using a simple SQL-like query language. Given the temporal nature of Stream Analytics queries, it is important to specify a timestamp for every input event.  By default, Stream Analytics will use arrival time of the input event – e.g. if Event Hub is used as an…

0

Common Stream Analytics Query Patterns

We have received many questions and requests for help from customers who aren’t sure how to write their stream processing logic in the Stream Analytics Query Language.  We are happy to announce that we have released a guide that captures common query patterns and describes them fully with sample data, code snippets, and explanations: https://azure.microsoft.com/en-us/documentation/articles/stream-analytics-stream-analytics-query-patterns/…

0

Support for Custom Blob Output Path

One common request that we have received from Azure Stream Analytics users is the ability to specify the frequency that new blob output files are written.  Today’s update to ASA adds support for this via the Path Prefix Pattern output setting. The Path Prefix field has been renamed to Path Prefix Pattern and it now…

3

How To: Query for ‘All’ events and ‘No’ event scenarios

All and Nothing Azure Stream Analytics aspires to make low-latency, near-real-time stream computations as easy to use as typing a SQL query.  But while SQL (and its Stream Analytics dialect) is a powerful language, there are some “tricks of the trade” to quickly and easily expressing common stream-analytic concepts. Today, we look at two common…

0

Azure Stream Analytics used in Healthcare

Interested in seeing how our customers use Azure Stream Analytics to derive real time insights into their data in the Health care sector?   News article:  http://www.cio.com/article/2852000/healthcare/internet-of-things-helps-asthma-patients-breathe-easily.html You can find the complete case study here:  https://customers.microsoft.com/Pages/CustomerStory.aspx?recid=12216   Do you have a scenario you would like to collaborate with the product team to light up?  Contact…

0