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:…
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…
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…
Azure Function cannot process data streaming at 10 Hz
Hi I have the following architecture I am using the Azure Function to be able to save data in CosmosDB for Mongo since this is not supported by the Azure Streaming Analytics API and we need to use MongoDB. All is working but when I test with…
What are the feature supported by IoT Edge jobs for Stream Analytics
I want to write UDF for IoT Edge Stream Analytics, but seems it does not support by IoT Edge job of stream analytics. Can someone confirm, below limitations are still valid for IoT Edge jobs of stream analytics ? Found from this old link.
What factors affect the CPU utilization of Stream Analytics jobs?
I have two Stream Analytics jobs with the same configuration. One processes approximately 500k input events daily, while the other processes only 10k. However, the job that processes 10k input events daily consistently has a CPU utilization of 80%, an…
Azure Stream Analytics Job to save data to CosmosDB for Mongo
Hi I am creating an IoT solution I have connected the Azure Stream Analytics job with CosmosDB NoSQL and it si working fine, but I would like to connect to the CosmosDB for Mongo since we are used to work with Mongo DB. More over The CosmosDB is…
When will the Kafka as an input source for Azure Stream Analytics become general available
Kafka as an input source for Azure Stream Analytics is now almost in public preview for one year. I wonder when it becomes GA. Thanks See https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-kafka-input
Where is the difference between "Real-Time-Intelligence" in Fabric and "Azure Stream Analytics"?
HI, https://learn.microsoft.com/en-us/fabric/get-started/microsoft-fabric-overview has as components (a.o.) Real-Time Intelligence and some Synapse-Services. But in https://learn.microsoft.com/en-us/fabric/real-time-intelligence/overview Stream Analytics…
User is not licensed for Power BI
Hello. I am a student and have a project where i have to use powerBi. All other students in my class have access, but not me. My teacher tells me that i have to solve this on my own. i cant find any support from microsoft. Anyone that can help og guide…
Not seeing "WHen last Stopped" option while restarting the ASA job
Hello Experts, My azure stream analytics job is not showing me the 3rd option of "When Last stopped" when I want to restart a stopped job. I just have 2 options "Now" and "Custom" Has anyone faced it and fixed it ? Any…
I have placed a .json file in the Data storage container which I have created, While I am trying the fetch the data thorough inputs from Stream analytics job, the data is not loading
I have placed the .json file in the Storage account container(Date folder-->Time folder) as per the below screenshot. And here I am trying to fetch the data which is present in the .json file in one of the input of the Stream analytics job as per the…
Whether the Stream Analytics service supports modifying the row records of the output target database
Hi there, I now have a scenario where I receive data from EventHub through the Azure Stream Analytics service and UPDATE the data into the Azure Synapse table, now I know INSERT is supported, but I don't know if Update is supported. How to update…
Streaming analytics job can't connect to Azure Event Hub input when using user assigned managed identity.
I am trying to use an Azure event hub as an input for a streaming analytics (SA) job. I want to use a user-assigned managed identity for the SA job. I followed the directions in this documentation:…
Unexpected network error in Azure Table Storage when autoscale kicks in for Stream Analytics
Scenario I'm using Azure Stream Analytics (ASA) streaming data from Azure Event Hub to Azure Table Storage. I've enabled autoscale rule in ASA. When autoscale kicks in, I notice that there would be a few network errors observed from Azure…
Creating an Azure Stream Analytics Output with Postgresql datasource using az cli in powershell fails
When I try to create an Azure Stream Analytics Output with a Postgresql datasource using az cli in Powershell on an existing stream analytics job and a postgresql database, it fails returning (BadRequest) The JSON provided in the request body is invalid.…
IoT hub as input connectivity issue in stream analytics
Unable to connect to IoT Hub 'IoT' using connection string. Please make sure you have configured the IoT Hub input correctly. Exception details System.IO.IOException: The AMQP transport failed to open because the inner transport sasl59161 is closed. …
Bulk Inserts in Stream Analytic Jobs
Hi Microsoft Team, I have a stream analytics job which is using an event hub as an input and dedicated SQL pool (previously SQL DW) as an output. In the query activity of this dedicated SQL pool, I Can see multiple queries are running which is suing bulk…
Code error in "Return the last event in a window" example
In the example given at https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns#return-the-last-event-in-a-window it seems to me that the JOIN condition: ON DATEDIFF(minute, Input.Time,…
Send data to disable public access Azure SQL Database
Hi What i want to accomplish: Send data through azure with a refresh rate of 2 seconds too a power bi report. Java script sending on prem data via event hubs using stream analytics collected in an azure sql database in an azure sql server, all with…