Azure IoT
A category of Azure services for internet of things devices.
383 questions
2 answers
Data stream between stream analytics services and WebApp service/Web App vs data stream between SignalR and Web App
Hello All, We are developing a solution to collect PLC OPC tags(100 tage/data points every 5 minutes) and publish to Azure Cloud via IOT Hub. Data Flow : OPC UA -> Custom Data Acquisition Service--> IOT Hub--> Stream Analytics--> SQL…
asked 2021-12-13T05:57:18.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 99%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Muhammad Asad Ilyas
1
Reputation point
commented 2021-12-30T15:50:43.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 74%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AshokPeddakotla-MSFT
27,966
Reputation points
0 answers
Stream-Analytics-OutPut Event Issue
Hi, I am streaming files from blob storage and sending data event hub. This case some time data's are streamed properly but not sends from output evet to event hub. Basically some time output events are missing and event hub not receiving messages.…
asked 2021-12-02T09:17:14.477+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Prabhu Ranganathan
1
Reputation point
commented 2021-12-14T22:12:30.053+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
0 answers
stream analytics "test connection is not supported for data source type Microsoft.DBForPostgreSQL/servers/databases"
My stream analytics input is an Event Hub, and my output is an Azure Database for PostgreSQL flexible server instance. The input test connection works, and the test query works. I selected the existing DB instance from the dropdowns when creating the…
asked 2021-12-02T19:40:41.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 19%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ryan Shepherd
1
Reputation point
commented 2021-12-13T05:17:34.327+00:00
PRADEEPCHEEKATLA-MSFT
78,331
Reputation points Microsoft Employee
0 answers
Stream Analytics Edge automated deploymend and publish from a Visual Studio Project
Hi I am looking for the right way to build a JobTemplat.json from a Stream Analytics Edge Job created in a Visual Studio 2019 / 2022 Projekt and then publish it to a new created azure ressource. This all in a outomated way. For a Stream Analytics job…
asked 2021-11-25T07:31:54.107+00:00
Michael Helfenstein
1
Reputation point
commented 2021-11-29T11:32:08.93+00:00
PRADEEPCHEEKATLA-MSFT
78,331
Reputation points Microsoft Employee
1 answer
Azure Stream Analytics grammar
Does a grammar exist for Azure Stream Analytics query language? Like this one
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 81%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Stream Analytics jobs not working reference input Blob storage
I created an input from the Event Hub in the ASA - everything works. But when I add the source type - Reference, and add this source in the request, I get the error: "Not all inputs have data. Please make sure the input sources have data and…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 39%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Stream Analytics: SQL output and column order in SA query
Hi! I have a Stream Analytics query that sends data to several tables. Example: select node_info.timestamp_utc as timestamp_utc, node_info.node_name as node_name, props.battery_level as battery_level, …
asked 2021-10-27T18:37:21.197+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 55.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Jane Dickson
56
Reputation points
commented 2021-10-29T20:49:43.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
alexander.dimitrov
16
Reputation points
1 answer
Line break in string in Stream Analytics job
Hello. I have a stream analytics job that generates alarm messages on incoming data and sends them to the Message table where they get picked up by Twilio Text Message service. Here's my Stream Analytics query: case when max(lab_temp_alarm) = 1 or…
asked 2021-10-08T19:02:39.993+00:00
Jane Dickson
56
Reputation points
commented 2021-10-27T21:57:08.003+00:00
Jane Dickson
56
Reputation points
1 answer
Creation of function in azure stream analytics
Attached is a screen shot of a video regarding to uploading data from a iot device and visualize en Power Bi, the questions is the information showed is the result of a creation of the functions in a manual way or are created automatically? then I…
asked 2021-10-10T22:29:38.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 33%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
David Ramirez
1
Reputation point
commented 2021-10-19T09:14:51.023+00:00
PRADEEPCHEEKATLA-MSFT
78,331
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Stream Analytics: An unexpected error has occured and we have been notified. Please try again in a few minutes. [e9a17f93-d9e8-4720-846a-766e3a0ff267]
I have developed a ASA query to call ML model. It works fine in the VS code version. But when I copy it to the Azure it give the below error. After the error, the whole ASA job stopped working, no matter what you put in the query. I have tried to use…
asked 2021-10-06T18:02:36.343+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 85%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
Hansen Chen
101
Reputation points
accepted 2021-10-12T16:02:21.723+00:00
Hansen Chen
101
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure stream analytics documentation?
Where is the real documentation for Azure Stream Analytics? I want to change the delimiter of the CSV parser in code (not GUI). Where is the documentation for the input.json file, what attributes can I use and what values do they expect? br, Magnus
asked 2021-10-07T13:42:45.497+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 37%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Magnus Nilsson
21
Reputation points
accepted 2021-10-11T11:07:25.923+00:00
Magnus Nilsson
21
Reputation points
0 answers
How can you get just a weekly report from My Analytix instead of it combining into a monthly report
I would like to be able to see my weekly activities separate from all 4 weeks combined. Is this possible, and do I need to do something on my side? Thanks - DG
asked 2021-10-04T12:55:14.727+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 22%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Gadberry, Deb R
1
Reputation point
commented 2021-10-08T06:47:44.457+00:00
PRADEEPCHEEKATLA-MSFT
78,331
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
Azure Analytics Query to group the date and events
We have a huge data of analytics from past few months & I am looking for a query to group the events in the order of date.
asked 2021-08-31T18:11:10.417+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Amrutha
21
Reputation points
commented 2021-09-15T20:43:23.1+00:00
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Az web app to visualize SQL Tables for multiple devices
Hi. We are trying to migrate to Azure our app which shows data from multiple IoT devices arranged in SQL tables. From what we read we believe the trick will be done with IoT Hub + Stream Analitics + SQL Az database +Az Web App. We hava many grey areas as…
asked 2021-09-10T18:50:22.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 95%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQI%3C/text%3E%3C/svg%3E)
QST Ingeniería
26
Reputation points
commented 2021-09-13T12:54:08.427+00:00
Alberto Morillo
32,896
Reputation points MVP
1 answer
Error: Failed to add output " " Property 'groupId' length 12 is not acceptable range
Hard to understand error that I am getting from Azure, This error message from an output of an Analytics Stream is hard to understand. I am following the following tutorial. …
asked 2021-09-07T18:46:49.627+00:00
AdamB-4111
346
Reputation points
commented 2021-09-08T17:36:33.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,036
Reputation points
1 answer
How to check all failed message data in Stream Analytics log monitoring? Currently I can see only 5 example events in logs but I want to see all.
I am using a Stream analytics job to receive message from event hub, parse it and then insert it to Synapse table. Sometimes, there is some data conversion issue due to incorrect input data. I want to log all these input message which have some data…
asked 2021-09-01T10:10:33.043+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 93%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kumar, Parvendra
21
Reputation points
commented 2021-09-08T09:53:20.543+00:00
PRADEEPCHEEKATLA-MSFT
78,331
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Unable to extract values from Records column(JSON) using Stream analystics query language
Hi Team, I am unable to extract values from column 'records' (JSON format) in the query language. I have input stream from azure events hub, where the data is flowing in the form of JSON, When I try to query the individual columns from JSON, I…
asked 2021-08-17T18:21:14.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 91%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUB%3C/text%3E%3C/svg%3E)
Udaya Bhaskar (UBHAS.TI)
106
Reputation points
accepted 2021-09-01T13:37:59.453+00:00
Udaya Bhaskar (UBHAS.TI)
106
Reputation points
1 answer
One of the answers was accepted by the question author.
how to integrate stream analytics alert into geneva
I am setting up alert for stream analytic job in azure portal to monitor the job's performance. My question is when there is alert, how could I send a severity ticket to ICM? Thanks!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 31%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQL%3C/text%3E%3C/svg%3E)
1 answer
Stream Analytics - Reference Data
Hi, I have to set a pipe line to get data's into "stream analytics job service" from sql database directedly( should not use other layers/components Ex: Data factory, Event hubs etc between sql db and stream analytics job ) . But no stream…
asked 2021-08-12T04:41:37.507+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 45%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Prabhu Rsp
1
Reputation point
commented 2021-08-18T18:34:49.99+00:00
Sander van de Velde
29,271
Reputation points MVP
1 answer
Stream Analytics on the Edge with Azure Percept - Debugging route
I was able to follow these directions to get simulated temp sensor data through azure stream analytics on the edge. https://learn.microsoft.com/en-us/azure/iot-edge/tutorial-deploy-stream-analytics?view=iotedge-2020-11 I am now trying to modify…
asked 2021-07-23T14:10:48.633+00:00
Charles Elwood
106
Reputation points MVP
commented 2021-08-16T13:14:06.013+00:00
Charles Elwood
106
Reputation points MVP