Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
342 questions
1 answer
One of the answers was accepted by the question author.
User defined function doesn´t work because I use split method
I created user defined function in Azure stream analytics but this function doesn´t work because I use split method in my function Erorr code: Function 'splitandconverthex' resulted in an error: 'TypeError: Unable to get property 'split' of undefined…
asked 2023-10-11T15:48:50.1033333+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, 3%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Prachar Marek
20
Reputation points
commented 2023-10-18T14:39:22.5933333+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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,186
Reputation points
1 answer
One of the answers was accepted by the question author.
How to fix Microsoft Telcodata generator lab?
Hi, I just wanted to let you know that Microsoft's Telcogenerator.zip file is not work. Its not generating data once it used to when endpoint is been updated in the .exe config file. please look into the…
asked 2023-10-02T21:20:22.8466667+00:00
Ahad Sanji
25
Reputation points
accepted 2023-10-18T06:23:27.9733333+00:00
Ahad Sanji
25
Reputation points
0 answers
spark.readStream.text() text file from adls gen2 in databricks
file_path = "adl://<account-name>.dfs.core.windows.net/<container>/<path>/*.txt" streaming_df = spark.readStream \ .schema(schema) \ .text(file_path) query = streaming_df_transformed.writeStream \ …
asked 2023-10-05T15:48:37.58+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(147.20000000000002, 31%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sasidhar R. Kolli
20
Reputation points
commented 2023-10-17T18:56:28.1633333+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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
28,606
Reputation points Microsoft Employee
1 answer
How do I pass all the JSON packets received in that particular tumbling window to the Javascript UDF function from the Azure Stream Analytics Query?
Below is my Azure Stream Analytics query. In this query, I have set the tumbling window for 10 seconds, and whatever data I will be receiving in these 10 seconds, I wanted to pass these complete packets in the "AggrFunction(IotMessage)" UDF…
asked 2023-10-13T07:09:56.4366667+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(124.80000000000001, 90%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Deepak Chaurasiya
20
Reputation points
answered 2023-10-13T18:29:33.0366667+00:00
BhargavaGunnam-MSFT
28,606
Reputation points Microsoft Employee
0 answers
Azure Stream Analytics Test Query Does not work correctly with "WITH" clauses
Here is my query: WITH Stage1 AS ( SELECT records.ArrayValue.time as Recordedtime, records.ArrayValue.properties.flows as flows FROM [insights-logs-networksecuritygroupflowevent] as n CROSS APPLY GetArrayElements(n.records) AS…
asked 2023-10-02T06:32:13.2633333+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(230.39999999999998, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUJ%3C/text%3E%3C/svg%3E)
Ulla Jutila
0
Reputation points
commented 2023-10-09T17:59:34.4533333+00:00
BhargavaGunnam-MSFT
28,606
Reputation points Microsoft Employee
1 answer
Can Stream Analytics Update values in an existing table in Cosmos DB PostgreSQL?
Hi, I was wondering if I could update data in Cosmos DB for PostgreSQL table using Stream Analytics. I receive data through IOTHub and instead of adding rows of data I need to update values in different rows and columns. It seems that Stream Analytics…
asked 2023-09-25T00:36:43.08+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(25.6, 76%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Ben Rad
0
Reputation points
commented 2023-10-03T08:49:05.4166667+00:00
ShaikMaheer-MSFT
38,321
Reputation points Microsoft Employee
1 answer
Aggregate within 7 days
Hi All, I have a stream analytics query that aggregates data within 7 days, but seems it is not getting data through in the output (cosmos db). Here is my sample query: SELECT a.Name, b.TotalAmt FROM table1 AS a LEFT OUTER JOIN ( SELECT Id, SUM(Amount)…
asked 2023-09-26T19:48:56.24+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(19.2, 79%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
ggonong
11
Reputation points
commented 2023-10-03T08:43:58.49+00:00
ShaikMaheer-MSFT
38,321
Reputation points Microsoft Employee
1 answer
"custom autoscale" in Stream Analytics Job is not enabled
When Custom auto scale is enabled in Stream Analytics?
asked 2023-09-30T21:01:23.0633333+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(310.4, 36%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUS%3C/text%3E%3C/svg%3E)
Uma Sundar
5
Reputation points
answered 2023-10-02T23:06:30.8933333+00:00
QuantumCache
20,186
Reputation points
1 answer
One of the answers was accepted by the question author.
How to create azure data explorer output connection from stream analytics with az cli command
Hi Team, Could you please let us know how we can create output connection from stream analytics to azure data explorer with the help of AZ cli command or arm template ? I did not find the az cli command for azure data explorer output from stream…
asked 2023-02-14T13:43:04.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(268.8, 59%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SaurabhShukla
101
Reputation points
commented 2023-09-28T17:12:21.54+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
Are Azure Stream Analytics Job Resilient and zone redundant
Hi, I am looking at moving the current solution I have designed for a client to a production ready service. We are using a number of Azure resources from IaaS to PaaS. I am now looking at making this service production ready and need to understand the…
asked 2023-09-18T19:50:52.6+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, 76%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
GRAY Mike
161
Reputation points
commented 2023-09-28T08:37:49.3733333+00:00
PRADEEPCHEEKATLA-MSFT
84,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Is there anything else to pay attention to when using GetArrayElements() function？
I create a UDF in Azure Stream Analysis,but there was an error when I called it, as follows: //ExtractDynamicFields(inputData) is the UDF,and it return the array type CROSS APPLY GetArrayElements(ExtractDynamicFields(event)) AS arrayElement //error…
asked 2023-09-21T08:08:18.81+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, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
kunming jian
60
Reputation points
accepted 2023-09-25T07:04:29.6166667+00:00
kunming jian
60
Reputation points
1 answer
One of the answers was accepted by the question author.
Como enviar a saída do Stream Analytics para o Power BI
Ola pessoal, Estou tentando enviar dados do Stream Analytics para o Power BI. Gostaria de saber se o usuário que estou usando no Azure tem que ser o mesmo que tem a conta no Power BI. Abs
asked 2023-09-21T19:29:23.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(262.40000000000003, 85%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cássio Luis Ferreira
20
Reputation points
accepted 2023-09-21T21:49:06.1966667+00:00
Cássio Luis Ferreira
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Stop , Delete actions disabled in portal for running Stream Analytics
After start of Stream Analytics job I've created , there is no possibility to Stop it. And i lost access to all information related to the job. Based on log job started succesfully (and it is doing what is supposed to do). In IAM I'm reflected as owner…
asked 2023-09-19T14:19:36.3066667+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(3.2, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lukasz Nalichowski
20
Reputation points
accepted 2023-09-20T15:35:45.8733333+00:00
Lukasz Nalichowski
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How can I output data to output sources with the same alias?
My stream analysis job generates different types of data when processing input source data. How can I sequentially output these data to output sources with the same alias? Or what other methods are there？If I cannot output to an output source with the…
asked 2023-09-20T09:34:51.8+00:00
kunming jian
60
Reputation points
accepted 2023-09-20T11:17:02.2566667+00:00
kunming jian
60
Reputation points
1 answer
One of the answers was accepted by the question author.
What is the best solution for live dashboard using powerBI?
For a IoT solution for a device which sends tons of sensor data from more 10-12 sensors the device has, what is the best solution to have, A live dashboard showing last sensor values device state Live dashboard showing 1 hour of sensor values …
asked 2023-09-18T10:10:22.3266667+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(38.4, 80%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aurovind Sagar Epari
80
Reputation points
commented 2023-09-19T15:05:48.29+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
Stream Analytics job doesn't load properly
Hello, I am facing the problem with the Stream Analytics. I've set up a job without any issue. After starting the job, I can't do anything with the service. I can't start, stop, delete, move and even refresh the job on the overview page. I don't see any…
asked 2023-09-19T09:13:32.5933333+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(176, 97%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Martin Lžíčař
11
Reputation points
edited the question 2023-09-19T13:05:50.6433333+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(288, 47%, 37%)' 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)
AjayBathini-MSFT
40
Reputation points Microsoft Vendor
0 answers
How can I force cast JSON-number values to float?
Exactly what the image shows. I have numbers that not always have decimal numbers and I need them to be float. As the image shows, this doesn't work today. What am I doing wrong?
asked 2023-08-23T20:44:57.3933333+00:00
Nikolaos Delis
5
Reputation points
commented 2023-09-18T09:15:47.0266667+00:00
PRADEEPCHEEKATLA-MSFT
84,376
Reputation points Microsoft Employee
0 answers
Low level mistake - mismatch in naming found in Stream Analytics
I have been using Stream Analytics. I got iothub-pj001, iothub-pj005 and iothub-pj009 in the Iothub and these are set as input in the Stream Analytics. I found that I cannot find the option of iothub-pj001 last night when I was trying to add a new…
asked 2023-09-12T01:35:22.99+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(0, 75%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECI%3C/text%3E%3C/svg%3E)
Chiu I Keanu Leung
0
Reputation points
edited a comment 2023-09-13T07:22:53.8866667+00:00
Chiu I Keanu Leung
0
Reputation points
0 answers
Not able to use ML model to post and retrieve data
Hi I am using ml library model that results into below output on test page. False Alarm Prediction using Two Class Decision Forest [Predictive Exp.]' test returned ["8/10/2023 6:15:00 AM","User…
asked 2023-08-30T02:37:42.6366667+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(64, 17%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Rafay Hassan Niazi
6
Reputation points
commented 2023-09-06T00:07:46.8066667+00:00
QuantumCache
20,186
Reputation points
0 answers
Setup edge hub input for azure stream analytics using the azure cli or python SDK
I am trying to create an azure stream analytics job using azure cli or python SDK with both input and output as edge hub. I tried using None and GatewayMessageBus as the input types but both of them did not work. It gives an error message: (BadRequest)…
asked 2023-08-20T21:48:11.47+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(112.00000000000001, 42%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rajiv
10
Reputation points
commented 2023-09-01T22:39:03.4+00:00
LeelaRajeshSayana-MSFT
13,951
Reputation points