Microsoft Q&A

Azure Stream Analytics

221 questions

An Azure real-time analytics service designed for mission-critical workloads.

Browse all Azure tags

221 questions with Azure Stream Analytics tags

Sort by: Updated
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.

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
asked 2023-02-01T08:33:10.02+00:00
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
912 questions
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
275 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
357 questions
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 ?

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
248 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
2,596 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
357 questions
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: [ { …

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
685 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,613 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
685 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,638 questions
Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
660 questions
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 …

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,613 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
685 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,638 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
685 questions
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

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure SQL Database
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
357 questions
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…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
221 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
685 questions
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