Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Content
0 answers
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.
asked 2023-02-01T08:33:10.02+00:00
Kalyana Chakravarthy Darshanam
0
Reputation points
asked 2023-02-01T08:33:10.02+00:00
Kalyana Chakravarthy Darshanam
0
Reputation points
1 answer
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…
asked 2022-12-29T17:59:33.797+00:00
Satyam Chauhan
171
Reputation points
commented 2023-01-30T06:46:43.1066667+00:00
Satyam Chauhan
171
Reputation points
2 answers
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…
asked 2023-01-20T13:03:19.6333333+00:00
Saurabh Shukla
81
Reputation points
commented 2023-01-27T05:09:07.3766667+00:00
PRADEEPCHEEKATLA-MSFT
53,261
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
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 ?
asked 2023-01-23T10:01:36.0833333+00:00
Saurabh Shukla
81
Reputation points
commented 2023-01-24T20:30:44.1333333+00:00
Sander van de Velde
15,226
Reputation points Microsoft MVP
0 answers
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…
asked 2023-01-18T09:04:37.86+00:00
mar32811
6
Reputation points
commented 2023-01-23T21:43:23.84+00:00
HimanshuSinha-msft
17,641
Reputation points Microsoft Employee
1 answer
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…
asked 2023-01-16T19:28:55.2333333+00:00
Admin (KK)
96
Reputation points
commented 2023-01-21T17:25:58.3433333+00:00
Sander van de Velde
15,226
Reputation points Microsoft MVP
1 answer
One of the answers was accepted by the question author.
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: [ { …
asked 2023-01-05T19:11:45.85+00:00
Saurabh Shukla
81
Reputation points
edited the question 2023-01-19T22:47:11.9833333+00:00
KranthiPakala-MSFT
33,056
Reputation points Microsoft Employee
1 answer
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…
asked 2022-12-28T08:19:05.757+00:00
Amber Bhanarkar
1
Reputation point
edited the question 2023-01-19T20:03:37.7633333+00:00
HimanshuSinha-msft
17,641
Reputation points Microsoft Employee
0 answers
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…
asked 2022-01-31T10:28:49.45+00:00
Luca Pierpaoli
21
Reputation points
edited the question 2023-01-19T19:41:29.9866667+00:00
HimanshuSinha-msft
17,641
Reputation points Microsoft Employee
3 answers
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…
asked 2022-12-19T14:33:36.707+00:00
Umair Akhtar
41
Reputation points
commented 2023-01-17T12:51:50.2333333+00:00
LeelaRajeshSayana-MSFT
871
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
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…
asked 2023-01-11T13:20:38.51+00:00
Umair Akhtar
41
Reputation points
accepted 2023-01-16T23:00:36.14+00:00
Umair Akhtar
41
Reputation points
1 answer
One of the answers was accepted by the question author.
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 …
asked 2022-12-30T21:22:09.283+00:00
Admin (KK)
96
Reputation points
accepted 2023-01-09T19:39:56.183+00:00
Admin (KK)
96
Reputation points
2 answers
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…
asked 2022-12-15T12:59:07.13+00:00
Satyam Chauhan
171
Reputation points
commented 2023-01-05T17:47:36.767+00:00
HimanshuSinha-msft
17,641
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
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…
asked 2022-12-27T11:35:53.263+00:00
Umair Akhtar
41
Reputation points
answered 2022-12-30T07:36:39.25+00:00
Umair Akhtar
41
Reputation points
1 answer
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…
asked 2022-12-19T07:35:11.39+00:00
Vikas Rajareddy
21
Reputation points
answered 2022-12-29T02:43:04.52+00:00
Ashok Peddakotla
9,956
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
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…
asked 2022-09-06T11:22:59.673+00:00
Felix Nogal
41
Reputation points
commented 2022-12-28T07:33:37.08+00:00
Ruimin Wang
1
Reputation point
1 answer
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…
asked 2022-10-21T10:30:16.083+00:00
Pedro Heleno Isolani
6
Reputation points
commented 2022-12-13T14:45:10.003+00:00
Pedro Heleno Isolani
6
Reputation points
1 answer
Query Window is blank in Azure Stream Analytics
Query Window is blank. It's not showing any options to choose
asked 2022-12-06T17:25:34.677+00:00
Chandu Reddy
1
Reputation point
commented 2022-12-12T06:43:20.89+00:00
PRADEEPCHEEKATLA-MSFT
53,261
Reputation points Microsoft Employee
1 answer
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…
asked 2022-11-30T10:35:48.527+00:00
Vikas Rajareddy
21
Reputation points
commented 2022-12-12T06:31:01.76+00:00
Vikas Rajareddy
21
Reputation points
1 answer
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…
asked 2022-12-01T08:28:17.91+00:00
A. Wesemann
1
Reputation point
commented 2022-12-12T00:40:05.443+00:00
Sander van de Velde
15,226
Reputation points Microsoft MVP