Azure Stream Analytics feature comparison

With Azure Stream Analytics, you can create streaming solutions in the cloud and at the IoT Edge using Azure portal, Visual Studio, and Visual Studio Code. The tables in this article show which features are supported by each platform for both job types.

Note

Visual Studio and Visual Studio Code tools don't support jobs in the China East, China North, Germany Central, and Germany NorthEast regions.

Cloud job features

Feature	Portal	Visual Studio	Visual Studio Code
Cross platform	Mac Linux Windows	Windows	Mac Linux Windows
Script authoring	Yes	Yes	Yes
Script Intellisense	Syntax highlighting	Syntax highlighting Code completion Error marker	Syntax highlighting Code completion Error marker
Define all types of inputs, outputs, and job configurations	Yes	Yes	Yes
Source control	No	Yes	Yes
CI/CD support	Partial	Yes	Yes
Share inputs and outputs across multiple queries	No	Yes	Yes
Query testing with a sample file	Yes	Yes	Yes
Live data local testing	No	Yes	Yes
List jobs and view job entities	Yes	Yes	Yes
Export a job to a local project	No	Yes	Yes
Submit, start, and stop jobs	Yes	Yes	Yes
View job metrics and diagram	Yes	Yes	Yes
View job runtime errors	Yes	Yes	Yes
Resource logs	Yes	No	Yes
Custom message properties	Yes	Yes	Yes
C# custom code function and Deserializer	Read-only mode	Yes	Yes
JavaScript UDF and UDA	Yes	Yes	Windows only
Azure Machine Learning	Yes	Yes	Yes
Compatibility level	1.0 1.1 1.2 (default)	1.0 1.1 1.2 (default)	1.0 1.1 1.2 (default)
Built-in ML-based Anomaly Detection functions	Yes	Yes	Yes
Built-in GeoSpatial functions	Yes	Yes	Yes

IoT Edge job features

Feature	Portal	Visual Studio	Visual Studio Code
Job authoring	Yes	Yes	No
Source control	No	Yes	No
Export a job to a local project	No	Yes	No
Query testing with a sample file	Yes	Yes	No
Share inputs and outputs across multiple queries	No	Yes	No
C# UDF	No	Yes	No
Submit jobs	Yes	Yes	No
List jobs and view job entities	Yes	Yes	No
View job metrics and diagram	Yes	Partial	No
View job runtime errors	Yes	Partial	No
CI/CD support	No	No	No

Next steps

• Azure Stream Analytics on IoT Edge
• Tutorial: Write a C# user-defined function for Azure Stream Analytics IoT Edge job (Preview)
• Develop Stream Analytics IoT Edge jobs using Visual Studio tools
• Use Visual Studio to view Azure Stream Analytics jobs
• Explore Azure Stream Analytics with Visual Studio Code (Preview)