Content
Is there any service in Azure for Activity Feeds Management
I want to understand if there is any service in Azure to handle Activity Feeds Management to build a social media app. I am looking for a service similar to Stream.io as a managed service to handle the feeds management.


Connecting Azure stream analytics job output to Azure Cosmos db with private end point
Hi, In order to secure the cosmos DB we have enabled private access with Private end point. For this we created a private end-point with resource type Microsoft.AzureCosmosDB/databaseAccounts and Private DNS Zone privatelink.documents.azure.com for…


Issue while reading event hub data through stream analytics
Hello, I have json messages in event hub . I am trying to read those messages through stream analytics job. While reading the data I am getting below error, Exception of type 'Microsoft.Streaming.Adapters.Exceptions.EventHubAdapterException' was…


Unable to test the connection in stream analytics for Azure Data Explorer output
Hi Team, I am using Azure Data explorer as output to stream analytics jobs and whenever I am trying to test the connection it is showing below error. Could you please let me know why it is still in propagating state and not successful ?


Why did scaling not help on delayed Stream Analytics outputs?
Hello :) We have an Azure Function that sends a lot of data in a single format to an Event Hub, which sends it to a Stream Analytics, which forwards the data to multiple outputs. This have worked very good for a long time, but a couple of days ago I…


Issue with Azure Stream Analytics Job
Hello, I have json messages in event hub which are compressed using gzip. I am trying to read those messages by enabling compression field to gzip, however i am getting the following error. Exception of type…


Json parsing using stream analytics
Hi Team, I am using stream analytics to parse json object and I need to remove some of the columns and rename remaining columns from json object. Please find below input data and output data needed. Input Data: [ { …


Synapse Pool query return NULL values
I am sending data from IoT Hub to Stream Analytics and then to Synapse Pool. In stream analytics the data is coming completely fine as I want. But querying the data in Synapse pool is giving me NULL values for two columns i..e, 'dates' and 'times'. These…


Azure Stream Analytics - After restart it doesn't produce output anymore
SA worked fine for a few days. For maintenance reasons we had to stop some Azure Services including SA. Since last restart SA shows input data correctly and test queries work fine. The logs have no errors. The utilization of the SU is less…


Telemetry data JSON body is encrypted. IoT Message route is used to route data directly to Blob storage.
Hi, So I am running Advantech device on Rasberry Pi using ModBus which then use Node Red workflow and Azure IOT hub node to connect to Azure IOT hub directly. I am able to connect to IoT hub and telemetry data is being sent successfully to iot hub. In…


Start/Stop Stream Analytics Job REST API Authorisation error
Hi, So I am using a Power Automate flow which send REST API HTTP post request to start/stop the stream analytics. In first step, I am fetching the bearer token sucessfully for which I have created an app and did app registeration in azure active…


Issue with configuring the stream analytics job
I had created a stream analytics job which takes the data from event hub and need to be pushed to a sql table in dedicated sql pool. when i am trying to configure the output the sql pool i am getting the following error. Connection test failed …


What is the max degree of Parallelism suppoted by stream analytics?
Hi, We are using a stream analytics job with 1 streaming unit. The input is a IoT Hub and the output is Cosmos DB container. IoT hub is receiving 8 messages at the same time which is the Input in Stream Analytics, I want to know, are the messages…


Stream Analytics : Setting value for fixed variable in the query
Hi, So I have a AZ3166 device which I am using to connect with Azure Iot Hub and to Stream analytics. Currently, device is sending Temperature, Humidity and timestamp only. However, i need to define the Device ID in Stream analytics query for…


Azure Iothub deletes consumer group while doing a manula failover
We had created a stream analytics which had the Iothub had as the input. But, when we do a manual failover on the Azure iothub , The stream analytics through the below error showing consumer groups are deleted . Even though the Iothub had the…


Stream Analytics CI/CD npm package using Managed Identity
Hi We are trying to automate the build and deployment process for our Azure Stream Analytics. We have configured the Managed Identity so we do not have any credentials on the parameters file. We have configured the inputs and outputs with…


GetMetadataPropertyValue overrides field value
Microsoft Learn recommend using the unique EventId property with GetMetadataPropertyValue to generate a unique identifier for an event (i.e., a UUID). However, when the event message content has a field called eventid, this is overwritten when calling…


Query Window is blank in Azure Stream Analytics
Query Window is blank. It's not showing any options to choose


Avoid warnings on Azure stream anayltics outputs when the same data is injected to all outputs.
Currently I have the below situation There are 5 inputs(A,B,C,D,E) for the same eventhub with 5 different consumer groups. There are 5 outputs(M,N,O,P,Q) to SQL database having 5 different tables. There are 5 queries written in the job that…


The streaming job failed: Stream Analytics-job has validation errors: The input yourinputalias used in the query is not defined.
Good morning. I have created an Azure IOT hub that receives telemetry data from the KPN things IOT portal (It's Dutch). I then added the ASA job and specified input (coming from the IOT hub) and the output (Blob Storage/ADLS Gen2). The name of…

