Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
383 questions
1 answer
One of the answers was accepted by the question author.
How streaming data is processed in real time projects , which was ingested through azure event hubs
And I have few questions : How streaming data is processed in real time projects?, lets say my streaming data is stored in adls gen-2, where every minute a new blob file is created. Does it should be treated as batch data and should process…
asked 2025-03-10T21:16:06.5233333+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(60.8, 40%, 15%)' 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)
Prakash Mj
20
Reputation points
accepted 2025-03-12T04:37:50.0666667+00:00
Prakash Mj
20
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.
698 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,448 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
383 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,786 questions
Azure Event Grid
Azure Event Grid
An Azure event routing service designed for high availability, consistent performance, and dynamic scale.
427 questions
asked 2023-10-19T13:35:01.65+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
commented 2025-03-10T18:52:01.63+00:00
Prakash Mj
20
Reputation points
1 answer
Azure SQL DB not returning correct results
Hello All, I have a stream analytics job that is left outer joining an event hub dataset and a sql db reference table. When I left outer join the datasets, the result returns null: You can see the result in the picture. The column called LEDT should…
asked 2025-03-03T15:19:12.8+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(281.6, 74%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWW%3C/text%3E%3C/svg%3E)
Woebbeking, William K
0
Reputation points
commented 2025-03-10T10:09:00.39+00:00
AnnuKumari-MSFT
34,271
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Data Streaming Issue: Switching from Block Blobs to Append Blobs
I've recently made a change to my telemetry stream architecture that's causing some data loss, and I'm hoping to get some insights from those with experience. Current Setup & Issue Original configuration: Telemetry stream using Block Blobs New…
asked 2025-02-26T22:01:03.1966667+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, 28.999999999999996%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
Annie Zhou
40
Reputation points Microsoft Employee
accepted 2025-03-03T18:42:04.3533333+00:00
Annie Zhou
40
Reputation points Microsoft Employee
2 answers
Azure Stream Analytics - Can't Access Metadata
I am using stream analytics to consume event from EventHub and aggregate them into a Data Lake Storage account. I am trying to access the "applicationProperties" of the event to add it to the data. I have tried using but the main issue is…
asked 2025-02-21T14:40:23.6333333+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, 87%, 10%)' 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)
Quentin Levasseur
0
Reputation points
commented 2025-02-26T11:15:35.84+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, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
21,320
Reputation points Microsoft External Staff
1 answer
One of the answers was accepted by the question author.
Output from your job may be delayed. An unexpected problem is preventing us from automatically recovering your job. No input should be lost
I have an Azure Stream Analytics job, and I noticed that I am not receiving any data. I see the following error: "Output from your job may be delayed. An unexpected problem is preventing us from automatically recovering your job. No input should be…
![](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' %3ES%3C/text%3E%3C/svg%3E)
2 answers
How to fix We cannot connect to Event Hub partition [0] because the maximum number of allowed receivers per partition in a consumer group has been reached
We cannot connect to Event Hub partition [0] because the maximum number of allowed receivers per partition in a consumer group has been reached. Ensure that other Stream Analytics jobs or Service Bus Explorer are not using the same consumer group. The…
![](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(233.6, 78%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
1 answer
Debugging Data Loss in Stream Analytics to Event Hubs
A stream analytics job has been set up to transfer data from a blob storage account to Event Hubs and subsequently into a Kusto database. There is an observed data loss of 10% compared to the original blob storage account. What methods are available to…
asked 2025-02-06T19:15:05.0133333+00:00
Annie Zhou
40
Reputation points Microsoft Employee
edited a comment 2025-02-23T07:18:09.25+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, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesh Gurram
4,965
Reputation points Microsoft External Staff
2 answers
One of the answers was accepted by the question author.
Stream Analytics job does not stream the data to the database
I have a Python script that sends data to the IoT Hub using MQTT. A message routing configuration is set up to route the data to a Blob storage, and this part is working as expected—I can see the data in the storage. My next goal is to route the data to…
asked 2025-01-17T14:57:57.25+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, 35%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Klajderic Aljosa HSLU I
55
Reputation points
edited an answer 2025-02-21T12:02:28.8366667+00:00
Klajderic Aljosa HSLU I
55
Reputation points
1 answer
I am trying to configure cosmos db output in stream analytics job, getting error as This subpartitioned container has more than 1 partition key path please use `PartitionKeyPaths`, But there is no option to configure path in output settings
I am trying to configure cosmos db output in stream analytics job, getting error as This subpartitioned container has more than 1 partition key path please use PartitionKeyPaths, But there is no option to configure path in output settings. How this can…
asked 2025-02-11T05:26:33.39+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, 6%, 18%)' 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)
Rajesh Karuppiah
0
Reputation points
commented 2025-02-13T12:51:36.8466667+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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
9,910
Reputation points Microsoft External Staff
2 answers
One of the answers was accepted by the question author.
Stopping Stream Analytics Job
Hello, I just want to ask if stopping Stream Analytics Job also means it will stop incurring cost? or it needs to be deleted? Thank you.
![](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, 45%, 37%)' 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)
1 answer
Cannot start stream analytics job in Vnet (cannot acquire managed identity)
Hello, I have set up an Azure Stream Analytics job that is injected into a virtual network (VNet). The job is connected to the following resources, all of which are linked to the VNet via private endpoints: Storage Account: I authenticate using the…
asked 2025-02-05T00:18:00.9033333+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(188.79999999999998, 46%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Amien Bourram
0
Reputation points
answered 2025-02-05T19:16:53.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(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
14,560
Reputation points Microsoft External Staff
2 answers
One of the answers was accepted by the question author.
Adjusting Lateness Tolerance in Azure Stream Analytics
A query is being run using Azure Stream Analytics to send data binned by hour into an event hub, which subsequently sends it into a Kusto database. However, there appears to be an issue, as approximately 1,000 messages are missed each day. The logs…
asked 2025-01-16T02:56:18.8833333+00:00
Annie Zhou
40
Reputation points Microsoft Employee
accepted 2025-01-21T17:21:35.55+00:00
Annie Zhou
40
Reputation points Microsoft Employee
1 answer
Debugging Data Loss in Stream Analytics to Event Hubs and ADF
My goal is to stream telemetry data from blob storage files into a Azure Data Factory database. I have set up a stream analytics job that takes data from blob storage, bins it by hour, and then passes it through an event hub with two partitions in order…
asked 2025-01-16T03:01:19.43+00:00
Annie Zhou
40
Reputation points Microsoft Employee
commented 2025-01-20T06:43:15.5466667+00:00
phemanth
14,560
Reputation points Microsoft External Staff
1 answer
Stream RealTime data from an On Prem Microsoft Server to a Azure Data Lake.
There is a need for Real Time data to be collected from a On Prem SQL Server. This means ADF is not suitable because it only does batch. Azure Streaming Analytics only connects to Azure SQL Server and not on prem. Has anybody else encountered this and…
asked 2023-03-16T02:02:54.12+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, 50%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Sallie Worsley
5
Reputation points
commented 2025-01-17T23:10:26.6+00:00
Sander van de Velde | MVP
35,411
Reputation points MVP
1 answer
How to configure late arrival policy to handle events that arrive later than configured tolerance window
I want to configure a late arrival policy and increase the tolerance of my Stream Analytics. While I can see documentation explaining late arrival policies…
asked 2025-01-16T15:52:16.5+00:00
Annie Zhou
40
Reputation points Microsoft Employee
answered 2025-01-16T17:36:50.3866667+00:00
Ganesh Gurram
4,965
Reputation points Microsoft External Staff
1 answer
duplicate key value violates unique constraint
Hi, I'm experiencing this issue from time to time when inserting values into a PostgreSQL database as output from the stream analytic, every 15 minutes Here the detailed version of it: First Occurred: 1/7/2025 8:09:22 PM UTC | Resource Name:…
asked 2025-01-07T20:20:31.5433333+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(224.00000000000003, 69%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Augusto Piva
35
Reputation points
commented 2025-01-09T13:51:08.3766667+00:00
Augusto Piva
35
Reputation points
1 answer
One of the answers was accepted by the question author.
How to enable Stream Analytics Job in EAST US 2 EUAP and CENTRAL US EUAP canary regions?
We couldn't create Stream Analytics Jobs in our EUAP Canary Production Subscriptions on East US 2 EUAP and Central US EUAP. Could you help allow EUAP on these subscriptions or tell me which TSG or doc I should follow? Error:…
![](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, 47%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERZ%3C/text%3E%3C/svg%3E)
1 answer
Stream Analytics: Referring an input from blob storage in JOIN resulted "The join predicate is not time bounded. JOIN operation between data streams requires specifying max time distances between matching events. Please add DATEDIFF to the JOIN"
Hello, I'm trying to refer a blob storage input config in our query window to determine the threshold value of the event value. But while joining the 2 tables resulting in below error: The join predicate is not time bounded. JOIN operation between data…
asked 2024-12-15T23:39:13.72+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(76.8, 71%, 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)
azureutthunga6
0
Reputation points
commented 2024-12-18T15:34:31.5333333+00:00
Smaran Thoomu
21,320
Reputation points Microsoft External Staff
1 answer
Azure Stream Analytics Job Produces No Output Despite Successful Query Tests and No Runtime Error
Hello, I am encountering an issue with my Azure Stream Analytics job. The job runs without any errors in the monitoring metrics, and when I test the queries individually using the query editor, they produce the expected results. However, the job does not…
asked 2024-12-12T10:03:38.9733333+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(144, 22%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Thanaphon Amattayakul
0
Reputation points
commented 2024-12-18T01:47:13.46+00:00
Chandra Boorla
9,910
Reputation points Microsoft External Staff