| title | description | author | ms.author | ms.service | ms.topic | ms.date |
|---|---|---|---|---|---|---|
Azure Stream Analytics feature comparison |
This article compares the features supported for Azure Stream Analytics cloud and IoT Edge jobs in the Azure portal, Visual Studio, and Visual Studio Code. |
an-emma |
raan |
stream-analytics |
conceptual |
06/27/2019 |
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.
| 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 |
| 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 |
- 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)