Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,177 questions
1 answer
I have placed a .json file in the Data storage container which I have created, While I am trying the fetch the data thorough inputs from Stream analytics job, the data is not loading
I have placed the .json file in the Storage account container(Date folder-->Time folder) as per the below screenshot. And here I am trying to fetch the data which is present in the .json file in one of the input of the Stream analytics job as per the…
asked 2024-10-14T04:46:38.5933333+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(115.19999999999999, 95%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ayyappa Koosam
0
Reputation points
commented 2024-10-16T12:02:01.6333333+00:00
PRADEEPCHEEKATLA-MSFT
89,816
Reputation points Microsoft Employee
1 answer
When will the Kafka as an input source for Azure Stream Analytics become general available
Kafka as an input source for Azure Stream Analytics is now almost in public preview for one year. I wonder when it becomes GA. Thanks See https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-kafka-input
![](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(240, 57.99999999999999%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Streaming analytics job can't connect to Azure Event Hub input when using user assigned managed identity.
I am trying to use an Azure event hub as an input for a streaming analytics (SA) job. I want to use a user-assigned managed identity for the SA job. I followed the directions in this documentation:…
asked 2024-10-10T15:10:49.6566667+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(9.6, 55.00000000000001%, 10%)' 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)
byzantium
20
Reputation points
commented 2024-10-14T06:09:06.7766667+00:00
PRADEEPCHEEKATLA-MSFT
89,816
Reputation points Microsoft Employee
1 answer
Unexpected network error in Azure Table Storage when autoscale kicks in for Stream Analytics
Scenario I'm using Azure Stream Analytics (ASA) streaming data from Azure Event Hub to Azure Table Storage. I've enabled autoscale rule in ASA. When autoscale kicks in, I notice that there would be a few network errors observed from Azure…
![](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(224.00000000000003, 89%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
1 answer
Creating an Azure Stream Analytics Output with Postgresql datasource using az cli in powershell fails
When I try to create an Azure Stream Analytics Output with a Postgresql datasource using az cli in Powershell on an existing stream analytics job and a postgresql database, it fails returning (BadRequest) The JSON provided in the request body is invalid.…
asked 2024-10-03T07:47:52.1866667+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, 86%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
TWE (Thomas Weickmans)
0
Reputation points
edited a comment 2024-10-07T19:09:05.6266667+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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
16,155
Reputation points Microsoft Vendor
0 answers
IoT hub as input connectivity issue in stream analytics
Unable to connect to IoT Hub 'IoT' using connection string. Please make sure you have configured the IoT Hub input correctly. Exception details System.IO.IOException: The AMQP transport failed to open because the inner transport sasl59161 is closed. …
asked 2024-09-30T11:22:16.2133333+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, 71%, 38%)' 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)
Singh,Vikram,IN-Bangalore
0
Reputation points
commented 2024-09-30T21:16:57.31+00:00
Sander van de Velde | MVP
32,726
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Bulk Inserts in Stream Analytic Jobs
Hi Microsoft Team, I have a stream analytics job which is using an event hub as an input and dedicated SQL pool (previously SQL DW) as an output. In the query activity of this dedicated SQL pool, I Can see multiple queries are running which is suing bulk…
![](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, 93%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
1 answer
Code error in "Return the last event in a window" example
In the example given at https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns#return-the-last-event-in-a-window it seems to me that the JOIN condition: ON DATEDIFF(minute, Input.Time,…
asked 2024-08-31T13:00:34.9166667+00:00
David M. Rosenblum
5
Reputation points
commented 2024-09-14T17:26:12.2533333+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
2,715
Reputation points Microsoft Vendor
4 answers
Send data to disable public access Azure SQL Database
Hi What i want to accomplish: Send data through azure with a refresh rate of 2 seconds too a power bi report. Java script sending on prem data via event hubs using stream analytics collected in an azure sql database in an azure sql server, all with…
asked 2024-09-03T05:47:24.46+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(115.19999999999999, 18%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Petter Cavallin
0
Reputation points
answered 2024-09-13T09:05:47.2933333+00:00
Petter Cavallin
0
Reputation points
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…
asked 2023-08-14T21:58:52.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(176, 25%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Ian Campbell
0
Reputation points
commented 2024-09-12T15:35:53.8+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(179.20000000000002, 45%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jean-Marc Bonenfant
0
Reputation points
2 answers
Always got same 'OutputDataConversionError.TypeConversionError' , even I remove the datetime column in output in the Synapse DW sql pool, and got same error after delete and recreated stream analystic.
Always got same 'OutputDataConversionError.TypeConversionError' , even I remove the datetime column in output in Synapse DW sql pool, and got same error after delete and recreated stream analystic. Stream Input is event hub, get dignostic log from azure…
asked 2021-11-12T10:31:09.177+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(137.6, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
woodymoo
261
Reputation points
commented 2024-09-03T13:54:27.8766667+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(300.8, 25%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFR%3C/text%3E%3C/svg%3E)
Frank Rasche
0
Reputation points
3 answers
One of the answers was accepted by the question author.
'Microsoft.Streaming.Adapters.Exceptions.EventHubAdapterException' thrown when fetching AVRO events from eventhub
We have setup a client in our app that is pushing AVRO encoded events to Azure Eventhub. We are using Schema Registry to encode the events. To use the events in power BI we would like to process incoming events into JSON format and save into blob…
asked 2024-08-30T10:38:20.8766667+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(108.80000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
ronnyBravo
20
Reputation points
accepted 2024-09-03T06:12:48.14+00:00
ronnyBravo
20
Reputation points
1 answer
What roles do I need to assign to a user to allow him configure my Stream Analytics Job?
I want to allow Azure user to modify Stream Analytics Jobs - define input, set queries etc. I need to do so without giving them full control over the associated resource group. Is there a pre-build role for this in Azure? Or do I need to create a custom…
asked 2024-08-29T07:53:10.2+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(105.60000000000001, 5%, 20%)' 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)
Majda, Filip
0
Reputation points
commented 2024-09-02T16:25:53.9966667+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(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
10,735
Reputation points Microsoft Vendor
1 answer
Can Rest Get API be used in Azure Stream Analytics Job ?
Hello, I want to know the usage of REST API in Azure Stream Analytics Job. Maybe, the operation is such as below. Call REST Get API Process REST Get API response. Thanks
asked 2024-08-21T10:12:19.5333333+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, 31%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
시남 우
0
Reputation points
commented 2024-08-28T11:05:48.5366667+00:00
PRADEEPCHEEKATLA-MSFT
89,816
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Event Hubs Authentication Issue with Status Code 401 for Specific Customer Credentials
I am reaching out regarding an issue encountered with Azure Event Hubs authentication for one of our customers. Despite successfully authenticating for most users, we are facing a peculiar problem with a specific customer's credentials, resulting in a…
asked 2024-08-19T11:10:19.6166667+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(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sanjay M Santhosh
20
Reputation points
accepted 2024-08-27T08:50:04.1+00:00
Sanjay M Santhosh
20
Reputation points
2 answers
One of the answers was accepted by the question author.
PartitionKey in Stream Analytics and Event Hubs
Hello, I'm trying to learn more about event hub partitions. I'm running a simple .Net program to send 20 events to an Event Hub with 3 partitions. I then query the events with the input preview in stream analytics. The simple .Net program is…
asked 2024-07-29T01:01:07.6533333+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(25.6, 61%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Karl Gardner
185
Reputation points
accepted 2024-08-22T13:51:54.9666667+00:00
Karl Gardner
185
Reputation points
1 answer
One of the answers was accepted by the question author.
How can I stop an Azure Stream Analytics job if it shows an internal server error when I try to stop it?
Error Message: "Failed to stop Stream Analytics job 'transport-stream-analytics'. The service returned an internal server error. Please try again. [SessionID: 34fe3fab609d4862a51836c9c777bd52]" Attached is a screenshot, I have been trying to…
asked 2024-07-29T22:49:40.2733333+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, 9%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dwij Siyal
20
Reputation points
accepted 2024-07-29T23:05:20.54+00:00
Dwij Siyal
20
Reputation points
1 answer
Job doesn't start (Used output doesn't exist)
I created a simple job to stream data from Event Hub to PowerBi (Pro license). Data preview shows the events. Testing the output connection to PowerBi is successfull. The system assigned managed identity has a contributor role in the PowerBI…
asked 2024-07-16T06:42:50.9233333+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(214.4, 83%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Verschaetse Kristof
25
Reputation points
commented 2024-07-22T05:08:43.66+00:00
PRADEEPCHEEKATLA-MSFT
89,816
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Watermark Delay Issues + Streaming Ingestion
Hello, I'm using the azure stream analytics to filter the devices in the event hub and output them in different tables. The issue I'm having is that it's not streaming the data on dashboards that it's getting. For example, it should show (stream) new…
asked 2024-06-26T21:19:25.6033333+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(35.2, 89%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nathan Sommer
40
Reputation points
commented 2024-07-05T13:18:43.4366667+00:00
Nathan Sommer
40
Reputation points
0 answers
Cannot select other SU value for minimum/maximum other than the defult in Stream Anaylitcs jobs autoscale
We have an Azure Stream Analytics job where we should set up autoscale as the input events have a peak within a day regularly and rest of day would need less streaming units with lower workload. When set up a rule in the custom scale, the only selectable…
asked 2024-07-02T12:42:43.88+00:00
Barnabas Nagy
0
Reputation points
edited a comment 2024-07-04T15:14:16.8066667+00:00
Sander van de Velde | MVP
32,726
Reputation points MVP