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,973 questions
1 answer
One of the answers was accepted by the question author.
Whether the Stream Analytics service supports modifying the row records of the output target database
Hi there, I now have a scenario where I receive data from EventHub through the Azure Stream Analytics service and UPDATE the data into the Azure Synapse table, now I know INSERT is supported, but I don't know if Update is supported. How to update…
![](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, 53%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
1 answer
Not seeing "WHen last Stopped" option while restarting the ASA job
Hello Experts, My azure stream analytics job is not showing me the 3rd option of "When Last stopped" when I want to restart a stopped job. I just have 2 options "Now" and "Custom" Has anyone faced it and fixed it ? Any…
asked 2024-10-31T16:09:07.8666667+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, 98%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
ARAVIND MOHANDAS
0
Reputation points
edited the question 2024-10-31T21:43:14.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(12.8, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VarunTha
9,105
Reputation points Microsoft Vendor
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
asked 2024-10-14T15:52:11.8866667+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(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)
hoi
0
Reputation points
commented 2024-10-22T08:16:26.47+00:00
PRADEEPCHEEKATLA-MSFT
90,146
Reputation points Microsoft Employee
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
90,146
Reputation points Microsoft Employee
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
90,146
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,555
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,736
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,950
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
266
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
11,125
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
90,146
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
190
Reputation points
accepted 2024-08-22T13:51:54.9666667+00:00
Karl Gardner
190
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
90,146
Reputation points Microsoft Employee