AzureFunBytes Reminder - Intro to @Azure Stream Analytics with @fleid_bi - 02/17/2022
Tags: azure, vscode, analyitics, sql
Published: 2022-02-16 16:31:49

AzureFunBytes is a weekly opportunity to learn more about the fundamentals and foundations that make up Azure. It's a chance for me to understand more about what people across the Azure organization do and how they do it. Every week we get together at 11 AM Pacific on [Microsoft LearnTV](https://cda.ms/226) and learn more about Azure.

When: February 17, 2022 11 AM Pacific / 2 PM Eastern
Where: [Microsoft LearnTV](https://cda.ms/226)

![AzureFunBytes animation](https://res.cloudinary.com/practicaldev/image/fetch/s--Z7BxBMz1--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_66%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/j2xzw2g664tj31jij13t.gif)

This week on AzureFunBytes we’ll be discussing how to best get started in stream processing with Azure Stream Analytics. [Azure Stream Analytics](https://azure.microsoft.com/services/stream-analytics) is a real-time analytics service that lets you define streaming jobs in SQL. Once deployed, these jobs will subscribe to streaming inputs like Event Hub, and filter, enrich, transform, join, or aggregate events as they come.

Stream Analytics offers multiple experiences for developers. Small work such as demos and prototypes can be quickly addressed in the Azure Portal. But most users will find that VS Code delivers the most complete developer experience for Stream Analytics via the [ASA Tools](https://marketplace.visualstudio.com/items?itemName=ms-bigdatatools.vscode-asa) extension.

To help get started understanding ASA jobs, I've reached out to Microsoft Senior Product Manager [Florian Eiden](https://twitter.com/fleid_bi).

{% youtube 3BzXTN-9vwY %}

Our planned agenda:

- High level intro to stream processing – what Stream Analytics does
- The Azure Stream Analytics service, when to use it vs Functions or Data Factory
- The local development experience in VS Code: writing a query, debugging and testing

## **Local development of Azure Stream Analytics jobs**

There are many benefits to developing Stream Analytics jobs locally in VS Code.

 It’s easier to get started. As we support [fully local job runs](https://docs.microsoft.com/en-us/azure/stream-analytics/visual-studio-code-local-run), with sample/mock input files, there is no need to set up an input event hub and find a way to produce events. In this case there is no need to have an Azure subscription, and development costs are non-existent. And if a streaming source is available, we also support [local runs on live inputs](https://docs.microsoft.com/en-us/azure/stream-analytics/visual-studio-code-local-run-all).

 The developer feedback loop is much shorter with local development. Running a query only takes a few seconds. Debugging a query is accelerated. Stream processing is not an easy domain to grasp, having quick feedback on what works or not on a query is a must. In addition we offer unit-testing via our [npm cicd package](https://docs.microsoft.com/en-us/azure/stream-analytics/cicd-tools?tabs=visual-studio-code): the best way to make sure a query will behave properly once deployed.

 Not to mention the obvious: local development unlocks source control, and greatly facilitates [CI/CD](https://docs.microsoft.com/en-us/azure/stream-analytics/cicd-overview).

So be part and let's learn about Azure Stream Analytics jobs together!

**About Florian Eiden:**

Florian is a Senior Product Manager on the Azure Stream Analytics team. He’s responsible for the SQL language used in Stream Analytics. He spent much of his career moving data in batches, and is now trying to speed things up. Born in France, now enjoying the Canadian Pacific Northwest with his family.

---

Learn about Azure fundamentals with me!

Live stream is normally found on Twitch, YouTube, and [LearnTV](https://cda.ms/226) at 11 AM PT / 2 PM ET Thursday. You can also find the recordings here as well:

[AzureFunBytes on Twitch](https://twitch.tv/azurefunbytes)
[AzureFunBytes on YouTube](https://aka.ms/jaygordononyoutube)
[Azure DevOps YouTube Channel](https://www.youtube.com/channel/UC-ikyViYMM69joIAv7dlMsA)
[Follow AzureFunBytes on Twitter](https://twitter.com/azurefunbytes)

**Useful docs:**
[Get $200 in free Azure Credit](https://cda.ms/219)
[Microsoft Learn: Introduction to Azure fundamentals](https://cda.ms/243) 
[Introduction to Azure Stream Analytics | Microsoft Docs](https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-introduction?WT.mc_id=modinfra-58004-jagord)
[Quickstart - Create an Azure Stream Analytics job in Visual Studio Code | Microsoft Docs](https://docs.microsoft.com/en-us/azure/stream-analytics/quick-create-visual-studio-code?WT.mc_id=modinfra-58004-jagord)
[Develop Azure Stream Analytics queries locally with Visual Studio Code | Microsoft Docs](https://docs.microsoft.com/en-us/azure/stream-analytics/visual-studio-code-local-run-all?WT.mc_id=modinfra-58004-jagord)
[Test an Azure Stream Analytics job locally with sample data using Visual Studio Code | Microsoft Docs](https://docs.microsoft.com/en-us/azure/stream-analytics/visual-studio-code-local-run?WT.mc_id=modinfra-58004-jagord)
[Input validation for better Azure Stream Analytics job resiliency | Microsoft Docs](https://docs.microsoft.com/en-us/azure/stream-analytics/input-validation?WT.mc_id=modinfra-58004-jagord)
[Understand time handling in Azure Stream Analytics | Microsoft Docs](https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-time-handling?WT.mc_id=modinfra-58004-jagord)
[Stream Analytics Query Language Reference - Stream Analytics Query | Microsoft Docs](https://docs.microsoft.com/en-us/stream-analytics-query/stream-analytics-query-language-reference?toc=https:%2f%2fdocs.microsoft.com%2fen-us%2fazure%2fstream-analytics%2ftoc.json&bc=https:%2f%2fdocs.microsoft.com%2fen-us%2fazure%2fbread%2ftoc.json?WT.mc_id=modinfra-58004-jagord)