Stream Analytics CI/CD npm package using Managed Identity

Felix Nogal 41 Reputation points
2022-09-06T11:22:59.673+00:00

Hi

We are trying to automate the build and deployment process for our Azure Stream Analytics. We have configured the Managed Identity so we do not have any credentials on the parameters file.
We have configured the inputs and outputs with "AuthenticationMode": "Msi" to use this managed identity but this is not working with Reference - SQL Database input types.

Here we have an Event Hub input with "AuthenticationMode": "Msi":
238215-image.png

And the generated object in the JobTemplate as expected:
238222-image.png

The Reference - SQL Database input type with "AuthenticationMode": "Msi":
238223-image.png

And the generated object in the JobTemplate without "authenticationMode" property:
238147-image.png

Is this a bug with the 'azure-streamanalytics-cicd' npm package or is this a problem with my input configuration?

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
13,672 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
237 questions
Accepted answer
  1. Joe Zhang 91 Reputation points Microsoft Employee
    2022-09-06T18:00:31.027+00:00

    We have not supported SQL MSI yet both in vs code and npm packages.

    this is one feature gap in our tooling side and will address this in October release

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest