Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Azure Stream Analytics gives you two tools for building streaming jobs: the Azure portal and the Azure Stream Analytics tools extension for Visual Studio Code. Use the extension to write, debug, and run your streaming query locally. Each tool supports a different set of features, so the right choice depends on your development workflow.
This article compares the features that the Azure portal and Visual Studio Code support so you can choose the tool that fits your needs.
Note
Visual Studio Code tools don't support jobs in the China East, China North, Germany Central, and Germany Northeast regions.
Cloud job features
The following table compares the cloud job authoring features that the Azure portal and the Visual Studio Code extension support, including source control, testing, monitoring, and language support.
| Feature | Portal | Visual Studio Code |
|---|---|---|
| Cross platform | Mac Linux Windows |
Mac Linux Windows |
| Script authoring | Yes | Yes |
| Script IntelliSense | Syntax highlighting | Syntax highlighting Code completion Error marker |
| Define all types of inputs, outputs, and job configurations | Yes | Yes |
| Source control | No | Yes |
| CI/CD support | Partial | Yes |
| Share inputs and outputs across multiple queries | No | Yes |
| Query testing with a sample file | Yes | Yes |
| Live data local testing | No | Yes |
| Time policy support in query testing | No | Yes |
| List jobs and view job entities | Yes | Yes |
| Export a job to a local project | No | Yes |
| Submit, start, and stop jobs | Yes | Yes |
| View job metrics and diagram | Yes | Yes |
| View job runtime errors | Yes | Yes |
| Resource logs | Yes | Yes |
| Custom message properties | Yes | Yes |
| C# custom code function and deserializer | Read-only mode | Yes |
| JavaScript UDF and UDA | Yes | Windows only |
| Azure Machine Learning | Yes | Yes |
| Compatibility level | 1.0 1.1 1.2 (default) |
1.0 1.1 1.2 (default) |
| Built-in ML-based anomaly detection functions | Yes | Yes |
| Built-in geospatial functions | Yes | Yes |
| Power BI output | Yes | No |
| Protobuf serialization | Yes | No |
| Autogranting managed identity permissions for added endpoints | Yes | No |
Related content
- 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)