Azure / Azure/azure-quickstart-templates

101-streamanalytics-create - Broken transformation query in main template

Open
#7,357 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
14.9k
Forks
16.2k
Avg merge
6d 21h
Merged PRs (30d)
6

Description

101-streamanalytics-create/azuredeploy.json
https://github.com/Azure/azure-quickstart-templates/blob/master/101-streamanalytics-create/azuredeploy.json

### Issue Details
Transformation query syntax using \r\n doesn't appear to work correctly.

`"query": "SELECT\r\n *\r\nINTO\r\n [YourOutputAlias]\r\nFROM\r\n [YourInputAlias]"`

Is there a way to format the query in an ARM template so that it ends up looking like it is supposed to in the Azure Portal? e.g.

```
SELECT *
INTO [YourOutputAlias]
FROM [YourInputAlias]
etc.
```

This GitHub sample template is the only one I have found that has an example transformation query. The official Microsoft documentation is vague https://docs.microsoft.com/en-us/azure/templates/microsoft.streamanalytics/2016-03-01/streamingjobs/transformations

It would also be interesting to understand why the transformation query is NOT retrievale as code in the Azure Resource Manager https://resources.azure.com/ (displays as "message": "No GET Url")

Thanks

### Repro steps (*if necessary, delete otherwise*)
See screenshot for details - running the template should produce the same results
https://i.stack.imgur.com/k8opu.png

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with 101-streamanalytics-create/azuredeploy.json and the transformation query shown in the issue. Run the template and compare how the query appears in the Azure Portal, then check the linked ARM template documentation and Azure Resource Manager behavior. Done means the template produces the intended query formatting or clearly documents the supported limitation.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure
Domain
cloud, infrastructure
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.