Azure / Azure/azure-quickstart-templates
101-streamanalytics-create - Broken transformation query in main template
- 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