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.
599 questions
0 answers
Stream Analytics Edge automated deploymend and publish from a Visual Studio Project
Hi I am looking for the right way to build a JobTemplat.json from a Stream Analytics Edge Job created in a Visual Studio 2019 / 2022 Projekt and then publish it to a new created azure ressource. This all in a outomated way. For a Stream Analytics job…
Azure IoT Edge
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2021-11-25T07:31:54.107+00:00
Michael Helfenstein
1
Reputation point
commented 2021-11-29T11:32:08.93+00:00
PRADEEPCHEEKATLA
90,661
Reputation points
Moderator
0 answers
How can you get just a weekly report from My Analytix instead of it combining into a monthly report
I would like to be able to see my weekly activities separate from all 4 weeks combined. Is this possible, and do I need to do something on my side? Thanks - DG
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2021-10-04T12:55:14.727+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 22%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Gadberry, Deb R
1
Reputation point
commented 2021-10-08T06:47:44.457+00:00
PRADEEPCHEEKATLA
90,661
Reputation points
Moderator
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.
397 questions
asked 2021-06-02T06:41:55.377+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 35%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
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.
397 questions
asked 2020-10-21T12:50:29.303+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 30%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
Abed ElRahman Ayoub
1
Reputation point
commented 2021-06-17T17:51:28.843+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 26%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
nidhi agarwal
16
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.
722 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2021-05-13T10:07:41.487+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 95%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sara, VK
1
Reputation point
commented 2021-05-25T15:21:47.597+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 59%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Himanshu Sinha
11
Reputation points
0 answers
Azure Stream Analytics - SQL - Showing 0 rows joining with reference input with SQL Server Reference input
Even reference data available in joining SQL Server reference input tables, no result and no errors FROM table, Event hub input JOIN tables, SQL Server reference input INTO, SQL Server table SELECT a.Id ,SUM(r.FYQ1__c) AS FYQ1__c …
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2021-02-12T03:44:30.003+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 46%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Akila Ariyarathne
1
Reputation point
commented 2021-03-02T11:14:57.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 33%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Akila Ariyarathne
1
Reputation point
0 answers
Disappearing files from Blob Storage
Hi everyone. I have recently set up an Azure IoT Hub that is accepting telemetry data from an MQTT source. I have also set up an Azure Stream Analytics Job which simply takes the input and writes it to a Gen 2 Storage account (Data Lake, Hierarchy…
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,563 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2021-01-21T11:49:11.787+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 40%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Scott
6
Reputation points
commented 2021-02-02T17:21:26.987+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,491
Reputation points Microsoft Employee
Moderator
0 answers
ASA degraded flag and no output when using JSON_VALUE in query
I get a degraded flag as soon as I use a JSON_VALUE command in my ASA query. The query works fine when I test it and there are no other errors reported when I run the job. Just no output and degraded message.
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2020-12-22T20:58:11.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 11%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NB
1
Reputation point
commented 2020-12-28T06:19:35.11+00:00
PRADEEPCHEEKATLA
90,661
Reputation points
Moderator
0 answers
How to troubleshoot UDF error in Stream Analytics?
My Stream Analytics jobs has multiple errors like this: { "Environment": "Prod", "Region": "North Europe", "time": "2020-10-03T00:04:22.9834272Z", "resourceId":…
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2020-11-11T14:01:23.453+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 56.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Mikael Falkvidd
1
Reputation point
commented 2020-12-15T18:01:33.457+00:00
Mikael Falkvidd
1
Reputation point
0 answers
Azure Stream Analytics Reference Input: SQL DB Snapshot Error
Hi Team, I am using SQL DB as Reference Input in Stream Analytics Job. When I Start the stream analytics job, Reference Input(SQL DB) shows following error: I did check my Storage Account Details and it looks correct. But not sure why…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,362 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2020-11-25T18:56:23.713+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 48%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kamlesh Khollam
21
Reputation points
commented 2020-12-08T10:46:38.66+00:00
PRADEEPCHEEKATLA
90,661
Reputation points
Moderator
0 answers
Delete specific contents of file in blob container
I have log files in container, I want to search a list of strings in the log file and delete the specific record of the file matching with the string and save the file in same container with same name. Say the log file is abc.txt 10/20/2020 …
Azure Storage Explorer
Azure Storage Explorer
An Azure tool that is used to manage cloud storage resources on Windows, macOS, and Linux.
292 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,203 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2020-10-23T19:00:04.617+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 2%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Amey Pimpley
1
Reputation point
commented 2020-10-23T20:59:45.92+00:00
Amey Pimpley
1
Reputation point
0 answers
Struggling with geting data into table via streaming job.
A total newbie question here. I have successfully set up a job to stream data directly to PowerBI. That is working correctly. However, I also need to gather some analytics to display in somewhat realtime. I created a second stream job with an output…
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2020-09-04T13:30:23.867+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 89%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Charles Sutton
1
Reputation point
commented 2020-09-30T15:58:09.847+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,156
Reputation points
0 answers
Realtime time data from on premise databases
Hi Suppose I have 8 databases on premise and if i want to implement the lambda architecture then How can i ETL the data from these on-premise databases into cloud databases/storage in realtime. Can i use the Event hub for this? Is there any…
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
722 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2020-09-22T11:49:17.047+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 44%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kuldeep Chitrakar
1
Reputation point
commented 2020-09-25T19:14:42.01+00:00
MartinJaffer-MSFT
26,156
Reputation points
0 answers
Stream Analytics job - input - error
I'm using IoT hub as input from my stream analytics job however getting following error - There was an error processing the request. Please try again in a few moments. it was working before however after some change in message routing of IoT hub…
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
asked 2020-07-03T08:13:08.523+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 98%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
vijay chouhan
6
Reputation points
commented 2020-07-10T16:41:02.647+00:00
HimanshuSinha-msft
19,491
Reputation points Microsoft Employee
Moderator