Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
342 questions
1 answer
Finding out viewers of shared videos
We record videos on Teams and share them with our staff. I want to find out the identity of the viewers, not just the number of unique viewers and video views. The videos are recorded by a "user" level user and are part of that user's…
asked 2023-12-12T14:42:35.42+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, 49%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Bill Howard
0
Reputation points
commented 2023-12-18T21:02:47.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(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
One of the answers was accepted by the question author.
How to fix this error "The streaming job failed: Stream Analytics job is only able to use up to 50 Streaming Units based on the provided query".Please adjust the number of Streaming Units or check the number of input partitions and update your query.
I have been experiencing this when I try to run Azure Stream Analytics v2 with 6 SUs or above .Below 6 SU it works fine. I have a simple query which only has CROSS APPLY and GET ARRAY ELEMENTS in it.I am fetching telemetry data arrays and converting them…
asked 2023-11-23T10:54:56.5733333+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(51.2, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rafay Khan
20
Reputation points
accepted 2023-12-13T14:02:04.1666667+00:00
Rafay Khan
20
Reputation points
1 answer
Decimal data type in Azure Stream Analytics
How can be managed a decimal data type with 20 as scale in Azure Stream Analytics without any aproximation?
asked 2023-12-11T14:00:43.32+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(128, 8%, 22%)' 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)
Anonymous
answered 2023-12-11T18:31:15.6666667+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, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
0 answers
Using multiple, mixed length Windows in Stream analytics query results in high (100%) SU memory utlization
I want to use Windows to collect both 3-hour and 1 day max, min, average and count of certain device messages arriving to iot hub. If I use both windows, as in code snippet, SU memory usage goes to 100%. If I use only one Window (does not matter which…
asked 2023-11-29T11:07:26.6166667+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(182.40000000000003, 6%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tornikoski, Veli-Matti
0
Reputation points
commented 2023-12-08T10:59:55.67+00:00
Tornikoski, Veli-Matti
0
Reputation points
1 answer
Can Azure stream analytics lose data?
~~ I have encountered two instances recently where data was lost in Azure Stream Analytics (ASA). The first instance occurred when I was using ASA to store data in Parquet format, which was sourced from IoT Hub. I had set the minimum batch count to…
asked 2023-11-20T07:27:16.89+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(246.4, 14.000000000000002%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
jane
60
Reputation points
commented 2023-12-01T06:31:41.2+00:00
PRADEEPCHEEKATLA-MSFT
84,376
Reputation points Microsoft Employee
1 answer
Error when sampling data: no data received from 1 partition
Hi, I'm working with ASA and using Blob Container as input. The data is present in the container. However, when I run the query, I get the following error: While sampling data, no data was received from '1' partitions. The path…
asked 2023-11-13T12:59:08.3233333+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(6.4, 46%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sutheswaran, Suwhathi
70
Reputation points
commented 2023-11-28T01:20:43.7066667+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
1 answer
Chaining Queries in Stream Analytics
How can I write multiple SQL queries where the output of one query serves as the input to the next query, and this process repeats for several levels? I am working with around 3 or more levels of queries.
asked 2023-11-25T05:33:16.8333333+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, 55.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
c.mavi01
0
Reputation points
answered 2023-11-25T13:10:29.3266667+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
ONE QUERY OUTPUT AS INPUT TO ANOTHER QUERY
HI, I want to write three or more queries where-in one query output is served as input two next query and subsequently it should go to some around 3 or more levels.
asked 2023-11-25T05:32:07.5366667+00:00
c.mavi01
0
Reputation points
answered 2023-11-25T13:07:29.99+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
2 answers
Stream Analytics - Possible to Change/Convert miliseconds to seconds ?
Hi, i wrote for ASA a query and i am facing with one colum here. But the time output is wrong i think and in my RDL Report Server i am also getting no correct results I need to convert somehow but not sure if this is correct way. SELECT Name as…
asked 2023-11-08T11:25:52.9533333+00:00
Sutheswaran, Suwhathi
70
Reputation points
commented 2023-11-20T08:46:46.2633333+00:00
PRADEEPCHEEKATLA-MSFT
84,376
Reputation points Microsoft Employee
0 answers
Facing error while creating Azure Stream Analytics job service
Hi Team, I am getting error while deploying an Azure Stream Analytics instance from UI. I am not using any ARM template. It says "Your deployment failed" and throws the below error. { "code": "NotFound", …
asked 2023-11-17T15:41:25.22+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(297.6, 15%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWM%3C/text%3E%3C/svg%3E)
WAQAR MEHDI
5
Reputation points
commented 2023-11-17T17:31:42.76+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
0 answers
Azure Stream Analytics output config json as managed identity to service bus queue
Hello I have an ASA job that is using managed identity to send messages to a service bus queue (this is working) however when trying to deploy changes the template that is generated expects parameters for SharedAccessPolicyName, which to my understanding…
asked 2023-11-15T18:56:35.8133333+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(297.6, 59%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
Wilson, Chris
0
Reputation points
commented 2023-11-16T18:02:46.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.
Looking for real-time data ingestion pattern with examples
My company is in the process of converting a monolithic application into microservices. We've decided that the data lake will be the Source of Truth. A consulting company got us started, but processing messages to the Silver layer in the data lake is…
asked 2023-11-02T14:10:45.32+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, 28.999999999999996%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jeff Born (J&CLT-ATL)
101
Reputation points
accepted 2023-11-13T17:15:05.34+00:00
Jeff Born (J&CLT-ATL)
101
Reputation points
3 answers
One of the answers was accepted by the question author.
How to fix azure.eventhub.exceptions.AuthenticationError: CBS Token authentication failed
I'm attempting to run a sample event generator to familiarize myself with Azure Event Hubs and Azure Stream Analytics. import asyncio from azure.eventhub.aio import EventHubProducerClient from azure.eventhub import EventData import json import…
asked 2023-02-26T03:27:04.21+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(108.80000000000001, 93%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bill LaLonde
50
Reputation points
answered 2023-11-09T07:01:27.02+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, 87%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mariyam Thomas
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Stream Analytics Job - no output in SQL
Hello Team, i am facing with Stream Analytics Job with Output for SQL. I wrote a query and the output showing me the results which I expects. But somehow the results is not showing in my SQL table. I am running out of ideas. Not sure why it’s not…
asked 2023-11-01T18:52:40.7266667+00:00
Sutheswaran, Suwhathi
70
Reputation points
commented 2023-11-08T12:03:44.4766667+00:00
Sutheswaran, Suwhathi
70
Reputation points
1 answer
ASA: Encountered error when communicating with EventHub: Exceeded the maximum number of allowed receivers per partition in a consumer group which is 5
https://stackoverflow.com/questions/74305395/exceeded-the-maximum-number-of-allowed-receivers-azure-stream-analytics-job-con I have read and followed the suggestion from the link above but the ASA still throws me the same error so I made some…
asked 2023-09-12T02:28:07.35+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
commented 2023-10-31T07:59:07.9633333+00:00
Chiu I Keanu Leung
0
Reputation points
1 answer
WebApp Stream logs not showing in Logs table AppServiceConsoleLogs
Hello, we have a linux WebApp, we have some logging that we can see in the Stream logs, but I can not see the logs in the AppServiceConsoleLogs table (is empty). Can somebody help with the issue?
asked 2023-10-25T10:41:54.38+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(28.799999999999997, 65%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
Virginia Lopez - External
0
Reputation points
commented 2023-10-31T03:54:29.6333333+00:00
brtrach-MSFT
15,786
Reputation points Microsoft Employee
1 answer
Azure Stream analytics map column when writing parquet files
I was trying to use the capture feature for eventhub, writing Parquet files to blob storage. The UI passed me for creating a Azure Stream Analytics. I have a Json structure in the eventhub, which contains an object field, like the…
asked 2023-10-19T10:42:05.63+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, 83%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Eran Shemesh
0
Reputation points Microsoft Employee
commented 2023-10-30T10:59:55.2466667+00:00
PRADEEPCHEEKATLA-MSFT
84,376
Reputation points Microsoft Employee
1 answer
Stream Analytics job is lock
Hi, my SAJ is blocked, not working, I can't see inputs, outputs or query. The controls on the main service page (Start job; Delete; Move) are disabled. What could be wrong? Thanks JD
asked 2023-10-20T08:37:27.46+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, 71%, 39%)' 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)
Jaroslav Dyrčík
0
Reputation points
answered 2023-10-20T11:21:01.41+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Stream analytics
The Stream Analytics job works, it's just that it does not show in the Cosmos DB container. I am not sure whether it is my partition key that is incorrect.
asked 2023-10-19T20:29:16.98+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, 50%, 10%)' 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)
Given Mnisi
40
Reputation points
accepted 2023-10-19T22:57:34.4866667+00:00
Given Mnisi
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure stream analytics
I get this error when I want to display the data generated from this script
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
591 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,821 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
342 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,517 questions
Azure Event Grid
Azure Event Grid
An Azure event routing service designed for high availability, consistent performance, and dynamic scale.
343 questions
asked 2023-10-19T13:35:01.65+00:00
Given Mnisi
40
Reputation points
accepted 2023-10-19T19:45:53.7766667+00:00
Given Mnisi
40
Reputation points