An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.