Azure Stream Analytics Tools

Preview

Microsoft

|
4,224 installs
| (2) | Free
Author, local test and submit Azure Stream Analytics jobs.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Stream Analytics Tools for Visual Studio Code (Preview)

Author, manage and test your Stream analytics job both locally and in the cloud with rich IntelliSense and native source control.

Prerequisites

Getting started tutorials

Supported Operating Systems

  • Windows, macOS, Linux

Features

Manage and author job

  • Create new Stream Analytics cloud projects
  • Export existing jobs in the cloud to local projects
  • Author Stream Analytics query with rich IntelliSense
    • Syntax coloring, auto completion, error marker
    • Input column, UDF/UDA, temp result name auto completion
  • Configure inputs, outputs and job properties
  • Preview local and live input data
  • Create JavaScript function (UDF/UDA)

Test job locally

  • Test job locally using local sample data
  • Test job locally against live stream input

Compile and submit job

  • Compile job and generate ARM templates
    • Compile in Visual Studio Code
    • Compile on an arbitrary machine using azure-streamanalytics-cicd npm package
  • Submit job to Azure

Stream Analytics Explorer

  • List jobs in the cloud
  • View inputs, outputs, job query and job configurations
  • Start/stop job, open job view in Azure portal

Current Limitations

  • Germany Central, Germany North and all China regions are not supported.
  • This extension only works for Stream Analytics cloud jobs.
  • Only Mangened Identity authentication is supported for Power BI as output sink.
  • Only Mangened Identity authentication is supported for Azure Data Lake Storage Gen1 as output sink.
  • Azure Machine Learning function is not supported.
  • .NET use-defined funtions and deserializers are not supported.
  • Opening a job in Azure portal in Stream Analytics Explorer is not supported on Linux.
  • The following features are not supported in local testing.
    • JavaScript function on Linux and Mac.
    • Use free IoT Hub as input and input the password manually without selecting from subcriptions.

Create Stream Analytics project

  • Create new Stream Analytics projects

    Create Project

  • Export existing jobs in the cloud to local projects

    Export to local project

  • Author Stream Analytics query

    Author script

  • Add inputs or outputs

    Add input

  • Preview inputs

    Preview input

  • Configure job properties

    Configure job properties

  • Create JavaScript function (UDF/UDA)

    JavaScript UDF

Compile Stream Analytics job

  • Compile script

    • Syntax check
    • Generate ARM templates for deployment

    Compile script

Local Run

  • Test locally with sample data.

    Test locally with sample data

  • Test locally against live stream input.

    Test locally against live stream input

Submit job to Azure

Submit job

Stream Analytics Explorer

  • List jobs in the cloud.

  • View inputs, outputs, job query and job configurations.

  • Start, stop, delete, refresh job and open job view in Azure portal

    Stream Analytics Explorer

npm package for CI/CD

The azure-streamanalytics-cicd NPM package is for auto deployement secenario. It can be used on an arbitrary machine.

Make sure the asaproj.json and JobConfig.json files are in the same folder with the script file.

azure-streamanalytics-cicd build -scriptPath <scriptFullPath> [-outputPath <outputPath>]

Found a Bug?