Microsoft Q&A

Azure Stream Analytics

283 questions

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

Browse all Azure tags

283 questions with Azure Stream Analytics tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

How to create azure data explorer output connection from stream analytics with az cli command

Hi Team, Could you please let us know how we can create output connection from stream analytics to azure data explorer with the help of AZ cli command or arm template ? I did not find the az cli command for azure data explorer output from stream…

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.
366 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-02-14T13:43:04.17+00:00
SaurabhShukla 101 Reputation points
commented 2023-09-28T17:12:21.54+00:00
Sander van de Velde 22,046 Reputation points MVP
1 answer

Are Azure Stream Analytics Job Resilient and zone redundant

Hi, I am looking at moving the current solution I have designed for a client to a production ready service. We are using a number of Azure resources from IaaS to PaaS. I am now looking at making this service production ready and need to understand the…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-18T19:50:52.6+00:00
GRAY Mike 41 Reputation points
commented 2023-09-28T08:37:49.3733333+00:00
PRADEEPCHEEKATLA-MSFT 66,241 Reputation points Microsoft Employee
0 answers

Aggregate within 7 days

Hi All, I have a stream analytics query that aggregates data within 7 days, but seems it is not getting data through in the output (cosmos db). Here is my sample query: SELECT a.Name, b.TotalAmt FROM table1 AS a LEFT OUTER JOIN ( SELECT Id, SUM(Amount)…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-26T19:48:56.24+00:00
ggonong 6 Reputation points
edited the question 2023-09-27T18:51:25.9733333+00:00
GeethaThatipatri-MSFT 21,486 Reputation points Microsoft Employee
1 answer

Can Stream Analytics Update values in an existing table in Cosmos DB PostgreSQL?

Hi, I was wondering if I could update data in Cosmos DB for PostgreSQL table using Stream Analytics. I receive data through IOTHub and instead of adding rows of data I need to update values in different rows and columns. It seems that Stream Analytics…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,200 questions
Azure Database for PostgreSQL
asked 2023-09-25T00:36:43.08+00:00
Ben Rad 0 Reputation points
commented 2023-09-26T16:40:28.31+00:00
ShaikMaheer-MSFT 34,546 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Is there anything else to pay attention to when using GetArrayElements() function?

I create a UDF in Azure Stream Analysis,but there was an error when I called it, as follows: //ExtractDynamicFields(inputData) is the UDF,and it return the array type CROSS APPLY GetArrayElements(ExtractDynamicFields(event)) AS arrayElement //error…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-21T08:08:18.81+00:00
kunming jian 40 Reputation points
accepted 2023-09-25T07:04:29.6166667+00:00
kunming jian 40 Reputation points
0 answers

ASA: Encountered error when communicating with EventHub: Exceeded the maximum number of allowed receivers per partition in a consumer group which is 5

https://stackoverflow.com/questions/74305395/exceeded-the-maximum-number-of-allowed-receivers-azure-stream-analytics-job-con I have read and followed the suggestion from the link above but the ASA still throws me the same error so I made some…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-12T02:28:07.35+00:00
Chiu I Keanu Leung 0 Reputation points
commented 2023-09-22T03:23:37.24+00:00
Chiu I Keanu Leung 0 Reputation points
1 answer One of the answers was accepted by the question author.

Como enviar a saída do Stream Analytics para o Power BI

Ola pessoal, Estou tentando enviar dados do Stream Analytics para o Power BI. Gostaria de saber se o usuário que estou usando no Azure tem que ser o mesmo que tem a conta no Power BI. Abs

PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
149 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-21T19:29:23.92+00:00
Cássio Luis Ferreira 20 Reputation points
accepted 2023-09-21T21:49:06.1966667+00:00
Cássio Luis Ferreira 20 Reputation points
1 answer One of the answers was accepted by the question author.

Stop , Delete actions disabled in portal for running Stream Analytics

After start of Stream Analytics job I've created , there is no possibility to Stop it. And i lost access to all information related to the job. Based on log job started succesfully (and it is doing what is supposed to do). In IAM I'm reflected as owner…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-19T14:19:36.3066667+00:00
Lukasz N 20 Reputation points
accepted 2023-09-20T15:35:45.8733333+00:00
Lukasz N 20 Reputation points
1 answer One of the answers was accepted by the question author.

How can I output data to output sources with the same alias?

My stream analysis job generates different types of data when processing input source data. How can I sequentially output these data to output sources with the same alias? Or what other methods are there?If I cannot output to an output source with the…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-20T09:34:51.8+00:00
kunming jian 40 Reputation points
accepted 2023-09-20T11:17:02.2566667+00:00
kunming jian 40 Reputation points
1 answer One of the answers was accepted by the question author.

What is the best solution for live dashboard using powerBI?

For a IoT solution for a device which sends tons of sensor data from more 10-12 sensors the device has, what is the best solution to have, A live dashboard showing last sensor values device state Live dashboard showing 1 hour of sensor values …

Azure IoT
Azure IoT
A category of Azure services for internet of things devices.
350 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-18T10:10:22.3266667+00:00
Aurovind Sagar Epari 80 Reputation points
commented 2023-09-19T15:05:48.29+00:00
Sander van de Velde 22,046 Reputation points MVP
1 answer

Stream Analytics job doesn't load properly

Hello, I am facing the problem with the Stream Analytics. I've set up a job without any issue. After starting the job, I can't do anything with the service. I can't start, stop, delete, move and even refresh the job on the overview page. I don't see any…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-19T09:13:32.5933333+00:00
Martin Lžíčař 11 Reputation points
edited the question 2023-09-19T13:05:50.6433333+00:00
AjayBathini-MSFT 30 Reputation points Microsoft Vendor
0 answers

How can I force cast JSON-number values to float?

Exactly what the image shows. I have numbers that not always have decimal numbers and I need them to be float. As the image shows, this doesn't work today. What am I doing wrong?

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-08-23T20:44:57.3933333+00:00
Nikolaos Delis 5 Reputation points
commented 2023-09-18T09:15:47.0266667+00:00
PRADEEPCHEEKATLA-MSFT 66,241 Reputation points Microsoft Employee
0 answers

Low level mistake - mismatch in naming found in Stream Analytics

I have been using Stream Analytics. I got iothub-pj001, iothub-pj005 and iothub-pj009 in the Iothub and these are set as input in the Stream Analytics. I found that I cannot find the option of iothub-pj001 last night when I was trying to add a new…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-09-12T01:35:22.99+00:00
Chiu I Keanu Leung 0 Reputation points
edited a comment 2023-09-13T07:22:53.8866667+00:00
Chiu I Keanu Leung 0 Reputation points
0 answers

Not able to use ML model to post and retrieve data

Hi I am using ml library model that results into below output on test page. False Alarm Prediction using Two Class Decision Forest [Predictive Exp.]' test returned ["8/10/2023 6:15:00 AM","User…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-08-30T02:37:42.6366667+00:00
Rafay Hassan Niazi 6 Reputation points
commented 2023-09-06T00:07:46.8066667+00:00
SatishBoddu-MSFT 18,606 Reputation points
0 answers

Setup edge hub input for azure stream analytics using the azure cli or python SDK

I am trying to create an azure stream analytics job using azure cli or python SDK with both input and output as edge hub. I tried using None and GatewayMessageBus as the input types but both of them did not work. It gives an error message: (BadRequest)…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
Azure IoT SDK
Azure IoT SDK
An Azure software development kit that facilitates building applications that connect to Azure IoT services.
195 questions
asked 2023-08-20T21:48:11.47+00:00
Rajiv 10 Reputation points
commented 2023-09-01T22:39:03.4+00:00
LeelaRajeshSayana-MSFT 8,281 Reputation points
0 answers

watermark keeps increasing and event are not processed in Stream Analytics

I have IoT package data coming in from Event Hub to Stream Analytics and then outputted to a Delta Lake before switching to Delta Lake, I had output as CSV and it worked fine, no watermark delays, resource utilization was stable and low. After switching…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-08-08T08:38:14.5+00:00
Audrius 1 Reputation point
commented 2023-08-29T04:38:03.6566667+00:00
KranthiPakala-MSFT 43,432 Reputation points Microsoft Employee
2 answers

I can't use the Azure Stream analytic no code editor

Hi community, It seems that I can't use the no-code editor in my Azure stream analytic resource. I think I match all the Pre requisites for using No-Code editor. But not aware if input and outputs are something that I can set, as once I set those this…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-08-23T20:15:18.47+00:00
Augusto Piva 10 Reputation points
commented 2023-08-24T18:25:26.26+00:00
Sander van de Velde 22,046 Reputation points MVP
0 answers

Azure Stream Analytic at-least-once guarantees is not 100% accurate

I have Azure Stream Analytic (ASA) that process data from the event hub as input. And this job is for the finance biz so it is heavily based on Event Delivery Guarantees at least once of Azure Stream Analytic. But recently we found out that some data…

Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
459 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-08-22T01:58:01.4166667+00:00
Adam .H 6 Reputation points
commented 2023-08-23T05:14:09.71+00:00
PRADEEPCHEEKATLA-MSFT 66,241 Reputation points Microsoft Employee
2 answers

Processing nested JSON data in stream analytics for real-time visualization

Hello, I'm trying to get my sensor data into Power Bi via stream analytics so I can visualize it in real time. I'm getting JSON messages sent to the IoT Hub that are nested. These messages are from two sensors and can be recognized by the nAdr variable…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-07-11T14:48:02.4+00:00
Miklik Petr 20 Reputation points
commented 2023-08-22T08:26:08.7566667+00:00
PRADEEPCHEEKATLA-MSFT 66,241 Reputation points Microsoft Employee
1 answer

Send an alert email upon a new event in the Azure Auth Methods | Registration and Reset log

Hi folks, I'd like to send an email to my admin team when a user in my org adds a new authentication method. These events appear in the Azure portal in: Azure Active Directory > Security > Authentication Methods > Registration & reset…

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
16,645 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
4,003 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
283 questions
asked 2023-08-14T21:58:52.21+00:00
Ian Campbell 0 Reputation points
commented 2023-08-17T08:02:03.5366667+00:00
Vasil Michev 79,546 Reputation points MVP