Azure Event Hubs
An Azure real-time data ingestion service.
562 questions
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] …
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
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…
![](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, 35%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
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 …
asked 2021-04-28T18:41:05.783+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(195.2, 38%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
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 @Anonymous , 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 before sending…
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
1 answer
Fletching events from iothub in Stream Analytics
My Stream Analytics Job can't get data from IoTHub
asked 2021-04-26T08:28:41.557+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(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDQ%3C/text%3E%3C/svg%3E)
Duong Quoc Thang
1
Reputation point
commented 2021-04-28T12:41:50.03+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
ASA job SQL database output error
I am getting the following log error when I attempt to run my stream analytics job: "Initialize Adapter: Failed to initialize output adapter SQLdatabase" Would appreciate some help on what causes this error? The query is simply saving…
2 answers
ASA job unable to Fetch events from IoT Hub
I have a very basic Azure stream analytics job that works perfectly when running. I have an IoT Hub as the input and SQL database as the output. The query editor page is unfortunately not loading the input data from the IoT hub. It just says…
asked 2021-04-19T13:46:53.61+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(195.2, 23%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
BParlour
26
Reputation points
commented 2021-04-27T19:20:36.39+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,381
Reputation points Microsoft Employee
1 answer
Can't test query on my Stream Analytics Job
When I click test query on my Stream Analytics Job I get a message that says "There is no data for the "datainput" entry. Make sure the input source has data and try again”. So I go to my input source, I click "test" and I get a…
asked 2021-04-19T20:27:14.217+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, 70%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Daniel Noguera
1
Reputation point
commented 2021-04-27T06:18:02.047+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
1 answer
Azure Stream Analytics config corruption
I created a stream analytics service but ended up deleting the underlying blob storage where SA seems to save its configs. Now I am unable to view any detail reg this service. Unable to delete this service either. Could I get some help on how to set this…
asked 2021-03-26T15:03:18.117+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(278.4, 68%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sandesh Balakrishna
1
Reputation point
commented 2021-04-07T11:29:54.753+00:00
Sandesh Balakrishna
1
Reputation point
1 answer
output details in stream analytics
Output details power bi { "shellProps": { "sessionId": "74957b833f0e42dcb7079f90ec5471af", "extName": "Microsoft_Azure_StreamAnalytics", "contentName": "PowerBIOutputBlade" },…
asked 2021-03-20T07:39:25.21+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(156.8, 94%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENT%3C/text%3E%3C/svg%3E)
Nino Topuria
1
Reputation point
commented 2021-04-02T18:11:53.547+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(134.4, 34%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENT%3C/text%3E%3C/svg%3E)
Nino Topuria
1
Reputation point
2 answers
Stream Analytics Output to BlobStorage Folder Structure and Time
We have a stream analytics job that is simply processing json files and passing them into cosmos or to another event hub. On the event hub we have capture events to make avro files for later consumption. We are having an issue there and have thought to…
asked 2021-03-31T16:43:10.957+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(156.8, 38%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
James "JC" Clark
1
Reputation point
commented 2021-04-02T17:40:32.77+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(32, 44%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Samara Soucy - MSFT
5,051
Reputation points
3 answers
Processing Azure Storage Logs to Azure SQL with Stream Analytics
Hi Azure Community! I have a Storage Account and a CDN to make my images and videos faster to download/view. I would like to count the views/downloads of my files periodically to an azure database, let's say every 2 hours. I was thinking of Azure…
asked 2021-03-25T10:56:45.873+00:00
simon brami
1
Reputation point
answered 2021-04-01T19:45:45.313+00:00
Samara Soucy - MSFT
5,051
Reputation points
1 answer
Temporary Error 504 in Stream Analytics when clicking on "Overview"
Hi, I am getting 504 errors from time to time when clicking on the "Overview" menu. After several seconds or some minutes, all ok... Location of Stream is "West Europe". On 15.03.2021 in the morning, two colleagues were working…
asked 2021-03-23T10:53:39.39+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, 4%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
JohnDoe Testing
6
Reputation points
commented 2021-03-30T01:40:29.823+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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,422
Reputation points Microsoft Employee
1 answer
Json Parse in Stream Analytics
Hello World, i'm trying to parse some data in Stream Analytics but i don't seem to be successfull. This is what i send into my IoT Hub: look below I want to access the Channel1_Temp and MyVariable2. In my Query Sample the Data Locks…
asked 2021-03-13T08:55:59.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(256, 26%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Julian Balles
1
Reputation point
commented 2021-03-29T09:56:04.007+00:00
Julian Balles
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Increase size of ASA Parquet file output
Is there a way to (further) increase the size of the parquet files written by ASA output? The current settings is "minimum rows: 10000" and "maximum time: 2 hours". However the files are written by ASA every 5 seconds and the size per…
asked 2020-09-03T16:00:19.647+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(281.6, 73%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
mpoeckl
161
Reputation points Microsoft Employee
commented 2021-03-22T18:51:26.213+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(281.6, 35%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jason Welch
26
Reputation points
1 answer
One of the answers was accepted by the question author.
How to use Azure Anomaly Detection on IOT edge module?
I want to demo a POC which sends data from SimulatedTemperatureSensor available on Azure Marketplace. This data should be sent to Stream Analytics module on Edge and then Anomaly Detection Module Should send only anomaly data to IOT Hub. I need some…
asked 2021-03-12T12:14:18.453+00:00
Anurag Shelar
181
Reputation points
commented 2021-03-22T11:53:07.517+00:00
Sander van de Velde
29,281
Reputation points MVP
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 …
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
1 answer
Azure Stream Analytics - throwing Unauthorized error
I am trying to set up Azure Stream Analytics for Eventhub, but it keep throwing error - Querying EventHub ---eventhubname--- returned an error: Management operation failed. status-code: 401, status-description: Unauthorized..
asked 2021-02-03T20:31:02.127+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, 46%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Bee aNad
1
Reputation point
commented 2021-02-17T11:45:57.31+00:00
PRADEEPCHEEKATLA-MSFT
78,576
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
SSIS ETL Tool
Is the latest version of SSIS a fully cloud-based ETL tool?
asked 2021-02-05T20:37:45.827+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(243.2, 35%, 33%)' 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)
Sridhar Vuligonda
21
Reputation points
accepted 2021-02-12T14:24:47.13+00:00
Sridhar Vuligonda
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Missing record in table storage (from stream analytics)
Hi everybody, I have a problem of missing records in a table storage account. I use a stream analytics job to send data from an IOTHub to a table storage. The stream analytics job seems working correctly (output event count seems correct). I expect…
asked 2021-02-10T09:25:32.913+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(83.2, 75%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
BERNARD Thomas
166
Reputation points
accepted 2021-02-10T15:54:10.157+00:00
BERNARD Thomas
166
Reputation points