Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
342 questions
0 answers
Cannot select other SU value for minimum/maximum other than the defult in Stream Anaylitcs jobs autoscale
We have an Azure Stream Analytics job where we should set up autoscale as the input events have a peak within a day regularly and rest of day would need less streaming units with lower workload. When set up a rule in the custom scale, the only selectable…
asked 2024-07-02T12:42:43.88+00:00
Barnabas Nagy
0
Reputation points
commented 2024-07-02T13:11:35.45+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
Watermark Delay Issues + Streaming Ingestion
Hello, I'm using the azure stream analytics to filter the devices in the event hub and output them in different tables. The issue I'm having is that it's not streaming the data on dashboards that it's getting. For example, it should show (stream) new…
asked 2024-06-26T21:19:25.6033333+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(35.2, 89%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nathan Sommer
0
Reputation points
answered 2024-07-01T19:45:24.38+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
0 answers
Custom power bi chart is not refreshing to visualize a streaming data, i have to refresh it manually to see the changes
I developed custom power bi chart & created an event hub data streaming but it is not refreshing to visualize a streaming data automatically, i have to refresh it manually to see the changes
asked 2024-06-21T14:23:28.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(12.8, 81%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kelele
0
Reputation points
commented 2024-06-24T18:45:32.5833333+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,526
Reputation points Microsoft Employee
3 answers
How can I get a report of who created resources in Azure Analytics?
Hello, I'm trying to get reports of who creates resources in Azure, for example, I have analytic workspaces created but would like to see who created?
asked 2022-03-04T14:40:28.227+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, 34%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lou Pereira
16
Reputation points
commented 2024-06-21T05:59:07.3+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
Azure stream analytics streaming job failed
Hi everyone, My ASA failed in the middle of the night with the following error: The input and output connectors also did not work the following day. Without doing anything, the connections re-established themselves after a day and I can start the ASA…
asked 2024-06-14T09:28:24.2933333+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(233.6, 35%, 32%)' 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)
Tiemen Vanderstraeten
0
Reputation points
commented 2024-06-19T04:23:37.72+00:00
PRADEEPCHEEKATLA-MSFT
83,966
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
The WHERE clause in Azure Stream Analytics is unable to perform conditional filtering
My metadata is in JSON format, and I'm attempting to utilize the WHERE clause to filter out data where the property name is 'type', but the filter condition is not working effectively. Could you advise on how to achieve this? Looking forward to your…
asked 2024-06-13T06:20:28.4866667+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
edited a comment 2024-06-18T06:26:35.5766667+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
0 answers
Stream Analytics does not refresh the input reference blob data when it is updated on the blob storage account
Hi Colleagues; I'm dealing with a problem with Stream Analytics jobs and their corresponding input reference blob data. Basically Stream Analytics is not refreshing the input reference snapshot when a new blob file has been created within the storage…
asked 2024-06-12T13:59:16.8033333+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, 43%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
zarcap
0
Reputation points
commented 2024-06-18T05:47:23.18+00:00
PRADEEPCHEEKATLA-MSFT
83,966
Reputation points Microsoft Employee
1 answer
How to fix this while integrating Machine Learning UDF function to Azure Stream Analytics
Hi, I am trying to integrate my ML endpoint with Azure Stream Analytics, but failing to do so as I cannot save the below details: Here is my scoring script for the endpoint: import os import logging import json import joblib from azureml.core.model…
asked 2024-06-04T15:28:29.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(185.6, 30%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Pradyumn Joshi
40
Reputation points
commented 2024-06-11T07:03:29.2833333+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Partition Key in Azure Event Hub and Stream Analytics
Hello, I am reading about Azure Event Hub with the ability to use a partition key to map incoming event data into specific partitions: https://video2.skills-academy.com/en-us/azure/event-hubs/event-hubs-scalability#mapping-of-events-to-partitions I am…
asked 2024-05-27T00:18:24.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(54.400000000000006, 88%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Karl Gardner
85
Reputation points
accepted 2024-05-28T14:05:12.8533333+00:00
Karl Gardner
85
Reputation points
1 answer
Problem with parsing data from a JSON field
I'm trying to process the log files with the following structure per…
asked 2024-05-20T23:53:38.33+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, 5%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Dragan Antanasković
0
Reputation points
commented 2024-05-23T20:29:20.7966667+00:00
Dragan Antanasković
0
Reputation points
1 answer
How does session window max duration check work in Stream Analytics ?
Hi, I have a question regarding the Session Window function in Stream Analytics. According to documentation I found, "If events keep occurring within the specified timeout, the session window will keep extending until maximum duration is reached.…
asked 2024-05-11T09:20:08.6133333+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, 57.00000000000001%, 22%)' 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)
Ahan Sarkar
0
Reputation points
commented 2024-05-23T16:54:45.38+00:00
ShaikMaheer-MSFT
38,321
Reputation points Microsoft Employee
2 answers
Why 'Custom App' option is not shown under 'Add Source' in event stream of Microsoft Fabric.
We are trying to consume messages from Kafka. Created a new event stream in Microsoft Fabric. 'Custom App' option is not shown under 'Add Source' or 'New Source' in event stream of Microsoft Fabric real-time analytics
asked 2024-05-11T11:04:14.82+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(44.800000000000004, 92%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Karthika Samidurai
0
Reputation points
commented 2024-05-20T07:19:29.7+00:00
PRADEEPCHEEKATLA-MSFT
83,966
Reputation points Microsoft Employee
0 answers
Error encountered while storing reference data snapshot into the storage account
Error encountered while storing reference data snapshot into the storage account
asked 2024-05-09T12:13:14.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(70.4, 71%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Kelele G Berhe
0
Reputation points
commented 2024-05-17T18:32:23.4466667+00:00
BhargavaGunnam-MSFT
28,526
Reputation points Microsoft Employee
0 answers
Connecting Streamanalytics to IoTHub
Hi all, We're facing the issue that since 2 days ag We're getting the problem that "Stream Analytics job has validation errors: Unable to connect to IoT Hub using connection string. Please make sure you have configured the IoT Hub input correctly. …
asked 2023-06-19T14:55:11.37+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, 81%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGQ%3C/text%3E%3C/svg%3E)
Georgios - QU
0
Reputation points
commented 2024-05-16T07:00:47.45+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(150.4, 15%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Keith Graham
0
Reputation points
1 answer
Unable to update Cosmos DB documents with Hierarchical partition keys using Azure Stream Analytics job
I have document in Cosmos DB with Hierarchical partition keys. I want to patch certain property value. But while running the job I am getting this error👇 The streaming job failed: Stream Analytics job has validation errors: Error connecting to…
asked 2024-03-01T13:02:56.9233333+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, 94%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Subhajit Mondal
10
Reputation points
commented 2024-04-26T10:37:26.4+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, 41%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
Luis Trinta
0
Reputation points
2 answers
One of the answers was accepted by the question author.
How to ingest CDC data from SQL DATA SYNC to Event hub?
Hi we have a scenario to implement real-time CDC from SQL DATA SYNC to Azure SQL DB. Which tools are good for near real-time processes and prices as well. By using data bricks we can merge stream data into delta lake. But How to ingest real-time…
asked 2020-11-10T12:28:43.067+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(16, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
THIMMAIAH GARI,PRASHANTH,,
201
Reputation points
edited an answer 2024-04-24T06:51:50.8266667+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(195.2, 91%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shane Blake
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Stream Analytics Jobs - Alert Creation for "Diagnostic: Diagnostic Error"
I have multiple Azure stream Analytics Jobs (more than 50 Azure Stream Analytics Jobs) in my subscription. One of the requirement we have is to create an Alert whenever there is a activity logged in Azure Portal --> Stream Analytics Job -->…
asked 2024-04-03T09:46:13.2933333+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(156.8, 9%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Vijayakumar Ganji
101
Reputation points
accepted 2024-04-04T21:20:06.1+00:00
Vijayakumar Ganji
101
Reputation points
3 answers
Im trying to send Data from my IoTHub Input to my Sql Database output, but tables stay empty?
Hello everyone, Im currently working on a university-project and I'm connecting my Raspberry Pi Pico with Azure. The Pico is sending temperature data, which is recieved in the IoTHub Input im my analytics stream, but when I'm trying to send the data to…
asked 2024-03-20T14:33:58.6733333+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(140.8, 89%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESO%3C/text%3E%3C/svg%3E)
Snack Overflow
0
Reputation points
answered 2024-03-20T15:53:31.9666667+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Data sync issue in Stream Analytics job to Azure SQL database
I am using the Raspberry Pi Azure IoT Online Simulator to push the data (in the interval of every 500 milli seconds) to Azure IoT hub (Basic Tier) using this link https://azure-samples.github.io/raspberry-pi-web-simulator/ I have configured Stream…
asked 2024-02-29T05:47:33.0566667+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(89.60000000000001, 41%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vishvanath Bhat
20
Reputation points
accepted 2024-03-14T10:38:44.5933333+00:00
Vishvanath Bhat
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Stream Analytics: Why does state of reference data retrieval not leave "In progress"
Hi, I'm using a CSV file from Azure Blob Storage as a reference input source in a Stream Analytics resource. Right now this file is updated every twenty minutes, but this will change to longer periods as our testing progresses. Within the activity logs…
asked 2024-03-13T08:40:16.1533333+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(160, 5%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Tobias Reinhardt
20
Reputation points
accepted 2024-03-14T08:11:56.1966667+00:00
Tobias Reinhardt
20
Reputation points