329 questions with Azure Stream Analytics tags

Sort by: Updated
1 answer

Azure Stream Analytics: File name prefix

While using ADLS Gen 1 as output for a Stream Analytics job, if the file path pattern doesn't contain a trailing slash (/), the last pattern in the file path is treated as a file name prefix. For example, if the path pattern is 'dir/{date}/{time}' the…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,315 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-03-30T13:38:40.213+00:00
Aris Konomis 6 Reputation points
commented 2021-08-03T08:14:35.983+00:00
Dheeraj 351 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Stream Analytics Module on Azure Percept Edge Device

Trying to Deploy stream analytics module to Azure Percept device. Following this tutorial here: https://learn.microsoft.com/en-us/azure/iot-edge/tutorial-deploy-stream-analytics?view=iotedge-2020-11 Steps to Duplicate : Created blob…

Azure Percept
Azure Percept
A comprehensive Azure platform with added security for creating edge artificial intelligence solutions.
70 questions
Azure IoT Edge
Azure IoT Edge
An Azure service that is used to deploy cloud workloads to run on internet of things (IoT) edge devices via standard containers.
525 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,093 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-07-21T18:23:00.41+00:00
Charles Elwood 106 Reputation points MVP
commented 2021-07-24T15:51:30.903+00:00
Charles Elwood 106 Reputation points MVP
1 answer

How to create powerBi dashboard for multiple devices automatically?

Hi All, I need help in creating multiple device dashboard using powerbi. Let's say i provision a device on azure IOTHub, and after successful registration. Registered device must be populated in power bi dashboard.

Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,093 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-07-19T10:33:58.21+00:00
Pradeep 1 Reputation point
commented 2021-07-21T17:56:04.253+00:00
KranthiPakala-MSFT 46,412 Reputation points Microsoft Employee
1 answer

Problem exposing GetMetadataPropertyValue in a streaming job with powerbi or blob storage outputs

Hi, I have a python script that sends device telemetry to iothub. I add a custom User/Application property called cpuAlert ****from azure.iot.device import IoTHubDeviceClient, Message, MethodResponse message.content_encoding='utf-8' …

Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,093 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-07-12T20:15:57.513+00:00
mpazure 116 Reputation points
commented 2021-07-14T11:19:44.487+00:00
Sander van de Velde 27,186 Reputation points MVP
1 answer

I am unable to send the data to SQL database through IoT hub using Stream analytics

When i start the process in stream analytics and then try to write a query in SQL, then it shows the process is degraded and shows a notification failed to initialize output adapter output stream.

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-06-23T10:18:26.337+00:00
Manikanta Kommur 1 Reputation point
commented 2021-06-29T11:33:25.397+00:00
PRADEEPCHEEKATLA-MSFT 75,286 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

How to add private endpoint in Stream Analytics cluster for Synapse workspace?

I want to add a private endpoint in Stream analytics cluster for Synapse sql database. My Synapse workspace is configured with in a Vnet. In private endpoint creation popup, Synapse resource is not available to select from resource list.

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.
4,253 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-06-18T05:36:18.403+00:00
Kumar, Parvendra 21 Reputation points
commented 2021-06-28T15:13:01.847+00:00
KranthiPakala-MSFT 46,412 Reputation points Microsoft Employee
1 answer

Keep getting `No subscription for receiving messages found for dthakkar-rpi-edge-device/EdgeTelementryASAAverage`

After deploying the azure stream analytics job on my edge device (Rasberry Pi 3), iotHub container logs keep showing No subscription for receiving messages found for dthakkar-rpi-edge-device/EdgeTelementryASAAverage, and the stream analytics job is not…

Azure IoT Edge
Azure IoT Edge
An Azure service that is used to deploy cloud workloads to run on internet of things (IoT) edge devices via standard containers.
525 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-06-27T20:58:21.32+00:00
Aditi Thakkar 1 Reputation point
answered 2021-06-28T11:16:58.773+00:00
António Sérgio Azevedo 7,661 Reputation points Microsoft Employee
1 answer

Azure Stream Analytics needs a better choice for the key column in an auto-created table

Azure Stream Analytics needs a better choice for the key column in an auto-created table I have the following tech stack: SQL Server on-prem running 2019 Change Data Capture (CDC) is enabled on one table for all columns Debezium is connecting…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-06-09T14:57:31.117+00:00
Goldner, Eli 1 Reputation point
commented 2021-06-24T06:39:03.917+00:00
PRADEEPCHEEKATLA-MSFT 75,286 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

IoT Hub to other services - Pricing

Hello, I'm studying an Azure solution with IoT Hub, which will ingest data from devices (only D2C, say through MQTT). The aim is to pass these data to an Azure Function, execute some computation, and save them in some DB (e.g.CosmosDB), or…

Azure IoT
Azure IoT
A category of Azure services for internet of things devices.
373 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,119 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,093 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-06-21T14:26:53.687+00:00
Mp 21 Reputation points
accepted 2021-06-22T10:28:02.113+00:00
Mp 21 Reputation points
0 answers

'InputDeserializerError.InvalidData' | Invalid Avro Format, drop invalid record

I am sending AVRO messages using Java Kafka API to event hub, and using stream analytics to route the data to BLOB Storage. Although after successfully producing the avro message to eventhub, under ASA logs, I can see Diagnostic error. …

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-06-02T06:41:55.377+00:00
Surya Agarwal 21 Reputation points
commented 2021-06-18T06:29:12.353+00:00
Surya Agarwal 21 Reputation points
0 answers

Stream Analytics Job Failed - unable to find assembly

I have configured the job and tested the whole things, where the input is working, query is collecting data, and output connection is working correctly. but when it comes to starting the job an error occur with the following warning. I'm trying to…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2020-10-21T12:50:29.303+00:00
Abed ElRahman Ayoub 1 Reputation point
commented 2021-06-17T17:51:28.843+00:00
nidhi agarwal 16 Reputation points
2 answers

How to perform stream analytics to simple export data from blob storage to table storage in regular intervals?

Hi, I am creating a stream analytics job in azure where data is exported and saved into table storage in azure. While I am able to do the data export when the stream analytic job starts, data export does not happen when job is still running since…

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
156 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-05-02T06:19:11.99+00:00
Jemimah Priyadarshini 1 Reputation point
commented 2021-06-16T23:18:37.257+00:00
MartinJaffer-MSFT 26,011 Reputation points
1 answer

Need help starting with Kafka server

I'm getting the following error when setting up confluent. That's why looking for alternative options for Kafka. {"code":"DeploymentFailed","message":"At least one resource deployment operation failed. Please list…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-06-11T15:53:53.447+00:00
Suresh Veeranala 1 Reputation point
commented 2021-06-16T11:05:32.44+00:00
PRADEEPCHEEKATLA-MSFT 75,286 Reputation points Microsoft Employee
1 answer

How to configure log analytics perf table as an input source to stream analytics job?

My requirement is to take data from log analytics perf table to stream analytic job as an input, in near real-time. I want, for example last 2 mins data, from the perf table, not the entire perf table. What is the best way to do this? Note: I already…

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-06-07T06:05:48.567+00:00
narmada 1 Reputation point
commented 2021-06-11T03:57:21.097+00:00
PRADEEPCHEEKATLA-MSFT 75,286 Reputation points Microsoft Employee
1 answer

Select DISTINCT column values from Input

Hi, I have multiple entries in table in a single sec, and I want to fetch the single value only, or we say distinct , is there any way we can do that, because DISTINCT is not allowed in stream analytics query

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-05-27T11:24:14.15+00:00
Akshay Sharma 1 Reputation point
commented 2021-06-02T16:42:56.947+00:00
KranthiPakala-MSFT 46,412 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Streamanalytics 'InputDeserializerError.InvalidData' error

Hello, I am trying to store my telemetry data to SQL database through stream analytics, I am getting a below mentioned error while trying to run a streaming job. "Source 'edgeinputstream' had 1 occurrences of kind…

Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,093 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-05-21T12:21:12.23+00:00
manjith 101 Reputation points
accepted 2021-05-26T08:55:11.323+00:00
manjith 101 Reputation points
0 answers

Event Hub Azure Stream Analytics size of record

I have some messages in Event Hub, and I want to determine the size of the message in bytes Thought I can do it in Azure Stream Analytics query SELECT t.metadata, t.payload, datalength(???? ) As SizeInBytes INTO [OutputAlias] …

Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
546 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-05-13T10:07:41.487+00:00
Sara, VK 1 Reputation point
commented 2021-05-25T15:21:47.597+00:00
Himanshu Sinha 11 Reputation points
4 answers

IoTHubQuota Exceeded

Im a developer with many years experience, but a newbie to azure and to python I am working on an IoT project where I have a number of Raspberry Pi units sending telemetry data to Azure. To facilitate this I have set up the following in the cloud 1…

Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,093 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-05-03T09:09:56.723+00:00
TH 6 Reputation points
answered 2021-05-04T06:56:11.73+00:00
TH 6 Reputation points
1 answer One of the answers was accepted by the question author.

How to handle data coming on IOT Hub which has multiple JSON formats?

Hello, I am working on a use case wherein I am sending data from az3166 iot device to IOT hub. Further I am running a stream analytics query to store data onto blob storage. The json for the same is …

Azure IoT Edge
Azure IoT Edge
An Azure service that is used to deploy cloud workloads to run on internet of things (IoT) edge devices via standard containers.
525 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,093 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-04-28T18:41:05.783+00:00
Anurag Shelar 181 Reputation points
accepted 2021-05-03T10:34:15.693+00:00
Anurag Shelar 181 Reputation points
1 answer One of the answers was accepted by the question author.

Stream Analytics on Edge with OPC UA Publisher

Hi @Sander van de Velde , followed your blog post for Getting Started with OPC UA Publisher . It made my life a lot more simpler. So Thank you for that. Now that I have my OPC Publisher module running on Edge, I would like to filter some data…

Azure IoT Edge
Azure IoT Edge
An Azure service that is used to deploy cloud workloads to run on internet of things (IoT) edge devices via standard containers.
525 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,093 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
asked 2021-04-28T18:50:18.247+00:00
Anurag Shelar 181 Reputation points
commented 2021-05-03T10:33:44.677+00:00
Anurag Shelar 181 Reputation points