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,694 questions
1 answer
how to update Azure Synapse spark pool with an exiting configuration in workspace
I have an existing Synapse configuration that has been set from the Synapse studio. Now I have a new spark pool created and want to bind that configuration to the pool. On the portal, it can be set on the sparkpool. But what is the programmatic way to do…
asked 2024-07-24T15:00:40.3766667+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(297.6, 80%, 38%)' 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)
BenZ
0
Reputation points
answered 2024-07-24T23:40:27.64+00:00
Amira Bedhiafi
20,101
Reputation points
2 answers
Why is FailureWebHook not executed in this case?
Please consider the following pipeline. The Execute Pipeline activity failed, so the ProcessTMONData notebook was skipped. Why was the failure webhook not triggered, as it's supposed to trigger when EITHER: ForEachEndpoint fails ProcessTMONData is…
asked 2024-07-23T12:10:36.8466667+00:00
Psychotechnopath
31
Reputation points
edited a comment 2024-07-24T23:18:18.8833333+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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT
29,041
Reputation points Microsoft Employee
0 answers
Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length
Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…
asked 2024-07-22T17:24:40.0233333+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, 76%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Michael King
0
Reputation points
commented 2024-07-24T17:34:49.14+00:00
Michael King
0
Reputation points
1 answer
Data is missing from management API using service principle. ex:resources
I have a requirement to load datasets from management.Azure.com (Management API), for example: Resources, Assessments, Tasks, and Secure Score. I have created a service principal in app registration and have been able to obtain the access token. However,…
asked 2024-07-11T22:11:50.9166667+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(246.4, 35%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mahesh Reddy
0
Reputation points
commented 2024-07-24T14:25:32.3466667+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
12,620
Reputation points Microsoft Vendor
1 answer
Synapse Link for Dataverse-SYN-806: Default storage container in Synapse workspace is not accessible error while enbling tables
Hi, I'm trying to setup a synapse link via dataverse to F&O. I'm able to setup the connection but when I enable tables sync status is throwing out error . Error details - SYN-806: Default storage container in Synapse workspace is not…
asked 2024-05-17T12:32:44.3633333+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(153.6, 92%, 24%)' 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)
Sandz
71
Reputation points
commented 2024-07-24T13:19:20.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(214.4, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Grossmann Manuel
0
Reputation points
0 answers
Synapse data warehouse and use
Hi friends, can we build a data mart kind of architecture for multiple domains in Synapse? How to built data marts for specific business entities in Synapse?
![](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(166.4, 15%, 26%)' 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)
4 answers
How to make manual failover to Azure Gen2 namespace enabled for disaster recovery plan
As a disaster recovery drill test for Azure adls namespace enabled accounts . I could see failover option for blob storage and but for adls namespace enabled accounts the failover option is disabled. Can anyone help in know how to do failover for 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(124.80000000000001, 85%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
![](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(150.4, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
1 answer
Problem with Power BI
Hi I am having a problem linking a button with a bookmark. When I click on the button nothing happens. I have referenced chatgpt and I can't get a straight answer. Thank you
asked 2024-07-24T04:40:03.14+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, 31%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGH%3C/text%3E%3C/svg%3E)
Geoff Hughes
0
Reputation points
answered 2024-07-24T06:13:35.91+00:00
PRADEEPCHEEKATLA-MSFT
85,586
Reputation points Microsoft Employee
0 answers
Connect to eventhub using Managed service identity (MSI) from Azure synapse analytics
I am trying to write the data to azure eventhubs from the azure synapse analytics notebook in scala using Managed service identity (MSI). Can you please help me with code for that. Note that i was able to successfully connect using the SAS key.
asked 2024-07-24T00:29:21.13+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(182.40000000000003, 94%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dheeraj Kumar Reddy Jogi
21
Reputation points Microsoft Employee
asked 2024-07-24T00:29:21.13+00:00
Dheeraj Kumar Reddy Jogi
21
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Connection issue to DB2 from synapse linked service
Hello All, I want to import data from DB2-on premises using azure synapse. Getting error while creating linked services using self hosted IR.
asked 2024-07-22T03:39:33.7133333+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(198.4, 21%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Ansari, Javed
20
Reputation points
accepted 2024-07-23T11:48:12.58+00:00
Ansari, Javed
20
Reputation points
1 answer
How to Monitor the Run of a Pipeline Triggered by a Web Activity in Azure Synapse/Data Factory?
I'm using Azure Synapse Analytics and have a pipeline that is triggered by a Web Activity. I want to monitor the run of this pipeline to check its status and debug any issues. Where can I find the monitoring options or logs specific to the pipeline runs…
asked 2024-07-23T10:14:28.4866667+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, 89%, 33%)' 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)
Kunal Kishore
0
Reputation points
answered 2024-07-23T10:53:36.78+00:00
Nandan Hegde
31,511
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Sink Mapping in Dataflow
Why am I getting the error "The result has 0 output columns. Please ensure at least one column is mapped" when previewing data in a Dataflow sink, even though the mapping seems correct?
![](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(233.6, 53%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Coud to Azure data migration
Hi friends, we have have to move 100gb data from Workday to azure storage , is there connector available for incremental data load?
1 answer
Can't query partitioned tables - Azure Synapse Link for Dataverse
Hi, we have a problem with accessing partitioned tables in Azure Synapse Workspace that were previously created by ingesting tables from Power Platform via Azure Synapse Link for Dataverse. Snapshot folder and .csv files are normally created but can't be…
asked 2023-03-20T16:05:06.8433333+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(208, 75%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Leo Milos
10
Reputation points
commented 2024-07-23T00:51:57.4366667+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(163.2, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gary Melhaff - US
6
Reputation points
1 answer
One of the answers was accepted by the question author.
Failed to create Livy Session for executing notebook
Hi, I am running notebook in microsoft fabric. All notebook activity suddenly stopped working today. Please see the error details below Notebook execution failed at Notebook service with http status code - '200', please check the Run logs on Notebook,…
asked 2024-02-28T16:03:37.9133333+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(297.6, 94%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Pinnaka, Sivannarayana
35
Reputation points
commented 2024-07-22T18:57:51.7666667+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, 32%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Ghosh, Paramita
5
Reputation points
2 answers
One of the answers was accepted by the question author.
Disaster Recovery setup/High Availbility
Hello again. I need to some help deciding on how to setup a DR solution. We have following things setup in DEV and UAT env: One subscription where DEV and UAT env reside using separate Vnet and subnets. Use Vnet Peering to connect both VPN gateway…
asked 2024-07-20T05:33:12.57+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, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
Xhevahir Mehalla
160
Reputation points
answered 2024-07-22T18:07:44.9933333+00:00
Xhevahir Mehalla
160
Reputation points
1 answer
Synapse workspace SHIR issue
Hello Team, We are using SHIR in synapse pipelines for data ingestion. Usually the data ingestion process would take 2+ hours to complete. But, recently the SHIR VM was restarted and after the restart the pipeline execution time is reduced to half (Its…
![](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, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
1 answer
Azure Synapse Link for Dataverse Has Fewer Fields than Export To Data Lake
I'm trying to migrate an Export to Data Lake solution to Azure Synapse Link. The Link is set up and functional, but I'm missing columns on some of the F&O tables. In particular, I'm missing a number of fields for DirPartyTable. I do not have…
asked 2024-07-17T21:48:19.1433333+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' %3ESC%3C/text%3E%3C/svg%3E)
Steven Cardella
0
Reputation points
commented 2024-07-22T15:35:00.8933333+00:00
Bhargava-MSFT
29,041
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure synapse and reserved pricing discount
From looking at the link here https://azureaggregator.wordpress.com/2021/02/09/data-flows-in-adf-and-synapse-now-support-reserved-instance-pricing/ and …
asked 2024-07-02T14:58:46.54+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, 39%, 17%)' 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)
MrFlinstone
531
Reputation points
accepted 2024-07-22T11:32:36.3866667+00:00
MrFlinstone
531
Reputation points
0 answers
synapse bicep code failing with Values for request parameters are invalid: keyvaultproperties.keyvaulturi
I have got a synapse workspace bicep code below, trying to add double encryption but currently faced with the error below.Tried different things to no avail, the issue here is that the code was decompiled from an ARM template, so not sure if the key…
asked 2024-07-16T22:45:29.1566667+00:00
MrFlinstone
531
Reputation points
commented 2024-07-22T07:49:11.07+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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
480
Reputation points Microsoft Vendor