How can I create a Data Explorer Stream Analytics output using ARM templates?

Question

I successfully manually configured a Stream Analytics Job that outputs data into Data Explorer. However, I am unable to set up my infrastructure pipeline using ARM templates. All the documentation only describes the other types of output (e.g. ServiceBus). I also tried exporting the template in the resource group, but this does not work for my Stream Analytics Job.

How can I configure this output using ARM templates?

Answer 1

For many of such issues, you can use the following process:

1. Setup the desired configuration manually
2. Check https://resources.azure.com and find your resource
3. OR Export the resource using the export template feature

In this case, resources.azure.com is sufficient.

If you look at the Data Explorer output resource, you will see the required ARM representation that you can use in your ARM template:

"name": "xxxxxxx",
"type": "Microsoft.StreamAnalytics/streamingjobs/outputs",
"properties": {
"datasource": {
  "type": "Microsoft.Kusto/clusters/databases",
  "properties": {
    "cluster": "https://yyyyy.westeurope.kusto.windows.net",
    "database": "mydatabase",
    "table": "mytable",
    "authenticationMode": "Msi"
  }
},