5,686 questions with Azure Synapse Analytics tags

Sort by: Updated
0 answers

Dataverse - Synapse change files not merged anymore

After an exceedance of the database capacity for our D365F&O environment, the merge of files in our dataverse (through synapse) is stopped. I still see the change files increasing on the storage account. After a lot of debugging I found the…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-20T08:21:30.07+00:00
Steven Bogaers 0 Reputation points
commented 2026-08-21T12:20:55.33+00:00
Himaja Y 260 Reputation points Microsoft External Staff Moderator
2 answers

I am trying to create Azure Synapse Analytics and its giving this error

{"code":"ValidationFailed","message":"Workspace request validation failed, check error details for more…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-13T16:20:36.4966667+00:00
MD IRFAN 5 Reputation points
commented 2026-08-20T11:03:39.7366667+00:00
SAI JAGADEESH KUDIPUDI 3,640 Reputation points Microsoft External Staff Moderator
1 answer

Synapse met 401 when read blob from another tenant with right sas token.

import org.apache.hadoop.fs.Path val storageAccount = "azureexpstorageprodwus2" val container = "release" val sasToken1 = "*******" spark.conf.set(s"fs.azure.sas.$container.$storageAccount.blob.core.windows.net",…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-18T08:56:12.5066667+00:00
Zhuohui Ren 0 Reputation points Microsoft Employee
answered 2026-08-19T07:58:26.9666667+00:00
Zhuohui Ren 0 Reputation points Microsoft Employee
1 answer

CI/CD Devops in Synapse

Hello, I literally am not sure why this happens, I don't think there are anything wrong with my trigger to run pipeline in my synapse, in my production they are all running fine. but this just happens recently when we would like to make some changes in…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-17T12:25:30.65+00:00
NickWong-8242 175 Reputation points
recommended 2026-08-18T17:52:03.4233333+00:00
Smaran Thoomu 415 Reputation points Microsoft External Staff Moderator
3 answers

Trying to copy for JSON API result to SQL*Server table, getting error on any data type I offer in the Sink

I am pulling a JSON result from an API, Azure Synapse via a Copy command. Data is coming in fine, and I can copy to the table if I do it via a temporary file in the middle. But I don't want to do that due to concurrency, cleanup, etc. I want to go…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-17T16:59:21.91+00:00
John Edwards 35 Reputation points
edited an answer 2026-08-18T13:18:37.76+00:00
John Edwards 35 Reputation points
1 answer

Synapse Diagnostic Emitter to EventHub using SNI is blocked due to "Adding or modifying trusted certificate subjects is not allowed by policy."

We are evaluating SFI-compliant authentication for Synapse Diagnostic Emitter to Event Hub. Currently, SNI Auto onboarding requires updating the trustedCertificateSubjects section in the App Registration manifest. However, due to the recent tenant policy…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-05T17:22:53.8933333+00:00
Muhesh Krishnamurthy 0 Reputation points Microsoft Employee
answered 2026-08-17T17:17:11.39+00:00
Smaran Thoomu 415 Reputation points Microsoft External Staff Moderator
2 answers

unable to execute the pipeline Novo_ERP_Export via 'Trigger now' or a schedule trigger within synapse spark pool

When executing the pipeline Novo_ERP_Export via 'Trigger now' or a schedule trigger within Power Apps, the RunErpExport (SynapseNotebook) activity fails within approximately 4–15 seconds. No Spark application is created, and attempting to open the…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-17T13:24:29.09+00:00
Abdulsamad 0 Reputation points
answered 2026-08-17T14:30:37.3633333+00:00
Himaja Y 260 Reputation points Microsoft External Staff Moderator
2 answers

Microsoft.Network still in registering state

I am trying to create a synapse analytics workspace and getting the error "subscriptionid not registerd with resource provider Microsoft.Network" . Microsoft.Network is still showing as registering in list of providers under subscription, does…

Azure Synapse Analytics
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.

5,686 questions
asked 2021-08-21T09:59:51+00:00
Pyapali, Vinod B 1 Reputation point
answered 2026-08-14T19:08:03.7633333+00:00
Mark Eburne 0 Reputation points
3 answers One of the answers was accepted by the question author.

Unable to create Synapse Administrator role access within Synapse Studio

The entra user that previusly held the Synapse Administrator role access within Synapse Studio have left the company and the user have been been deleted. I hold both the owner and the contributer access rights got the Synaps workspace - but I can't…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-07T13:20:58.5933333+00:00
Martin Hansen 20 Reputation points
commented 2026-08-10T08:00:15.65+00:00
Martin Hansen 20 Reputation points
1 answer

Unable to Connect Azure to AWS RDS – Request for Technical Assistance & Meeting

Dear Azure Support Team, Greetings from Allianz Insurance Sri Lanka. We are currently using Azure in conjunction with AWS for our M484 system anomaly detection solution, with both environments hosted via our FCP setup. However, we are facing an issue…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-06-22T06:19:30.23+00:00
Khan, Jazeem 0 Reputation points
commented 2026-08-06T21:52:09.66+00:00
Erland Sommarskog 136.7K Reputation points MVP Volunteer Moderator
1 answer

Error: DML Operations are not supported with external tables when attempting to delete a ROW on Synapse SQL Dataware Serverless Pool

Can someone let me know how to delete the first row from the External Table on Serverles SQL Pool When I execute the code DELETE TOP (1) FROM [dbo].[MyTable] I get the error: DML Operations are not supported with external tables.

Azure Synapse Analytics
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.

5,686 questions
asked 2022-12-19T14:06:56.293+00:00
Carlton Patterson 761 Reputation points
edited a comment 2026-08-05T16:41:27.2133333+00:00
Patrick O'Toole 0 Reputation points
1 answer

Automating Table Activation and Deployment for Synapse Link in Dynamics 365 Dataverse

I am using Synapse Link for Dataverse to bring data from Dynamics 365, where I need to manually activate each table to load data into Azure Data Lake Storage (ADLS) Gen2. I seek a solution to automate this activation process and to deploy the same…

Azure Synapse Analytics
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.

5,686 questions
asked 2024-08-02T15:17:52.7333333+00:00
Sriram M 40 Reputation points
commented 2026-08-05T15:41:00.57+00:00
Bechir BEN LTAIEF 0 Reputation points
0 answers

Synapse Dedicated SQL pools started getting slower last Tuesday

Synapse Dedicated SQL pools started getting slower last Tuesday Loads have tripled in time

Azure Synapse Analytics
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.

5,686 questions
asked 2026-08-04T01:34:55.8566667+00:00
Clavel, Christiane (MTL) 5 Reputation points
commented 2026-08-04T08:37:24.1333333+00:00
Manoj Kumar Boyini 19,510 Reputation points Microsoft External Staff Moderator
3 answers

57% increase in Synapse SQL Pool costs after enabling Private Links

Hello, I would like to ask for advice on how to optimize the costs of our Azure Synapse SQL Pool. We recently migrated our pipelines, connectors, and other components from an old Azure Synapse Workspace to a new one in order to use Private Links. Since…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-07-20T17:41:12.2466667+00:00
Michael Clemans 0 Reputation points
edited an answer 2026-07-29T16:50:42.8333333+00:00
Michael Clemans 140 Reputation points
3 answers

Could you please explain step by step guide for below question.

Transition your Azure Synapse Analytics workspaces to private links before 1 August 2026 You're receiving this email because you're using one or more Azure products with a managed identity and firewall exception for trusted services. As part of a…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-07-15T12:53:38.8566667+00:00
Kumarswami Mahantinamath 0 Reputation points
commented 2026-07-29T13:50:06.8533333+00:00
Jose Benjamin Solis Nolasco 11,301 Reputation points Volunteer Moderator
1 answer

linked service connectivity issues in Azure Synapse Studio

Hi Team, We are not able to test connection when Key vault link service checking that time gating error as mentions below.

Azure Synapse Analytics
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.

5,686 questions
asked 2026-06-16T12:53:09.07+00:00
Surendra Yadav 45 Reputation points
commented 2026-07-29T10:24:37.2366667+00:00
Kishor kumar Reddy Akki 50 Reputation points
0 answers

Join: Microsoft Azure Q&A Champions Program

The Microsoft Azure Q&A Champions Program recognizes and empowers a global community of internal and external Azure experts who help customers succeed by providing high-quality, trusted answers on Microsoft Q&A. The program scales expert led…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-05-25T23:49:30.21+00:00
Ashley Swearingen 0 Reputation points Microsoft External Staff Moderator
edited the question 2026-07-28T21:46:40.86+00:00
Ashley Swearingen 0 Reputation points Microsoft External Staff Moderator
1 answer

Synapse Workspace Deployment v2.5.0 Fails with Azure DevOps Federated Service Connection

We're attempting to deploy Synapse artifacts through Azure DevOps using the Synapse workspace deployment@2 task (version 2.5.0) and an Azure Resource Manager service connection configured with Workload Identity Federation (OIDC/Federated…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-07-28T16:31:37.1833333+00:00
Andreas Munson 0 Reputation points Microsoft Employee
answered 2026-07-28T17:15:51.5033333+00:00
Pilladi Padma Sai Manisha 11,705 Reputation points Microsoft External Staff Moderator
2 answers

Transition Azure Synapse Analytics workspace links - upcoming deadline

Hi, I noticed that this community post was shared a couple months ago, but without any further updates. The MS documentation still suggests that the 01 Aug 2026 deadline is in place. Is the change no longer of concern? It was suggested to us that this…

Azure Synapse Analytics
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.

5,686 questions
asked 2026-07-21T12:43:51.1666667+00:00
Shane Garvey 0 Reputation points
commented 2026-07-28T10:25:16.6766667+00:00
Shane Garvey 0 Reputation points
3 answers

How do I fix error: "There was an error trying to validate storage account name. Please try again"?

I was trying to Create and setup a Synapse workspace: Under Select Data Lake Storage Gen 2: I could not set Account name, by selecting Create New, although my Azure account is upgraded.

Azure Synapse Analytics
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.

5,686 questions
asked 2026-07-26T01:45:10.3933333+00:00
Dramane Salifou 20 Reputation points
answered 2026-07-26T05:53:49.8+00:00
Srikanth Chavithina 265 Reputation points Microsoft External Staff Moderator