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,499 questions
1 answer
Export dataverse data to in delta lake format not working
We have setup Azure Synapse Link for Dataverse and followed the documentation here: https://free.blessedness.top/en-us/power-apps/maker/data-platform/azure-synapse-link-synapse Export Microsoft Dataverse data in Delta Lake format - Power Apps |…
Azure Synapse Analytics
asked 2025-10-24T05:35:11.4133333+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(67.2, 34%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Alexander O'Reilly
0
Reputation points
commented 2025-10-26T11:21:39.5966667+00:00
Vinodh247
39,201
Reputation points MVP
Volunteer Moderator
1 answer
Cost of Azure Synapse Analytics - 1 vs 2 workspace (no Dedicated SQL Pool)
Sir/Madam, Need to understand the cost implications of planning for Synapse Analytics workspaces. Goal is to run Serverless Spark pool + Serverless SQL Pool. No plans of having Dedicated SQL Pool Is there a cost savings involved in running a single…
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,499 questions
asked 2025-10-24T19:08:29.19+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(118.4, 84%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Ram Narayanan
0
Reputation points
answered 2025-10-26T11:11:46.3966667+00:00
Vinodh247
39,201
Reputation points MVP
Volunteer Moderator
1 answer
Msg 13807, Level 16, State 1, Line 1 - Content of directory on path cannot be listed
I have got a synapse serverless SQL pool which was created by synapse link for Dynamics 365, I granted the user access to the serverless pool datalake database by assigning them the data reader role, the user queries a database table and gets 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,499 questions
asked 2025-10-14T19:31:30.0266667+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
706
Reputation points
commented 2025-10-24T18:17:46.92+00:00
MrFlinstone
706
Reputation points
1 answer
User gets "Login failed for user '<token-identified principal>'" when creating a DB in Synapse serverless SQL pool, despite having admin roles
Hi everyone, I have an Azure Synapse Analytics workspace, and I’m trying to give another user access to create a database in the Built-in serverless SQL pool. Here’s what I’ve done so far: In the Synapse workspace, under Manage → Security → Access…
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,499 questions
asked 2025-10-23T10:49:18.9866667+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, 13%, 13%)' 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)
Priyesh Shrestha
0
Reputation points
commented 2025-10-24T09:09:09.7366667+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(192, 47%, 28%)' 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)
Abhisek Mishra
845
Reputation points Microsoft External Staff
Moderator
2 answers
Generic error when running a Synapse pipeline containing a dataflow or trying to start a debug session
I have 2 Synapse instances in UK South. Error only occurs in one of them and doesn't seem to show up in the workspace logs - 'Internal server error executing the request.' This happens when trying to start debug cluster or run a pipeline with a dataflow…
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,499 questions
asked 2025-10-17T11:46:08.4666667+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(316.8, 73%, 40%)' 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)
MS
0
Reputation points
commented 2025-10-24T08:53:57.5633333+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(16, 2%, 11%)' 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)
Manoj Kumar Boyini
330
Reputation points Microsoft External Staff
Moderator
1 answer
Synapse Spark Pool starting time is significant longer than before
Hello, Over the past few months, I’ve noticed that Synapse Spark Pools take significantly longer to start. Previously, it took around 5 minutes to start a Spark Pool from scratch, but now it takes about 10 minutes. Is there any way to reduce the startup…
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,499 questions
asked 2025-10-23T14:27:32.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(115.19999999999999, 9%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZK%3C/text%3E%3C/svg%3E)
Z.K.Z
221
Reputation points
commented 2025-10-24T07:25:17.99+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
31,910
Reputation points Microsoft External Staff
Moderator
1 answer
Why are Spark Pools 3.4 in Synapse Taking Twice as Long to Start Up?
Why are Spark Pools 3.4 in Synapse Taking Twice as Long to Start Up? Since 3.5 Preview all pools are taking longer to spin up. This is also happening with custom environments in Fabric. Is this issue being worked on actively?
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,499 questions
asked 2025-10-22T18:55:46.0866667+00:00
Jesse Horn-Artera
0
Reputation points
commented 2025-10-24T07:23:36.0866667+00:00
Smaran Thoomu
31,910
Reputation points Microsoft External Staff
Moderator
1 answer
eRRO Spark job requested 80 vcores.
Ola boa tarde. Preciso de uma ajuda? Esta apresentando essa mensagem: InvalidHttpRequestToLivy: Your Spark job requested 80 vcores. However, the workspace has a 12 core limit. Try reducing the numbers of vcores requested or increasing your vcore quota.…
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,499 questions
asked 2025-10-23T20:01:41.0333333+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(224.00000000000003, 98%, 31%)' 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)
ITALIA COMERCIO E DISTRIBUIDORA LTDA
0
Reputation points
answered 2025-10-24T06:01:02.49+00:00
Smaran Thoomu
31,910
Reputation points Microsoft External Staff
Moderator
3 answers
Can't create Azure Synapse link to Dataverse in Power Platform despite having correct apache spark version
I have a dynamics environment in Canada region I have an Azure Synapse Workspace containing a Spark Pool in the Canada East region (there was no 'Canada' option) In Powerapps, I try to create a link to the Dataverse, and after choosing the Azure Synapse…
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,499 questions
asked 2025-10-21T17:50:16.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(108.80000000000001, 51%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Rick Fleischmann
0
Reputation points
accepted 2025-10-23T15:20:48.07+00:00
Rick Fleischmann
0
Reputation points
1 answer
Connect Azure Synapse to MongoDB Database with a Private Endpoint
We have a MongoDB Atlas Cluster deployed using Azure as our Cloud Provider and I'm trying to use a Private Endpoint to allow the connection from our Azure Synapse Workspace but I keep getting a Timeout Issue whenever I try to test the connection from 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,499 questions
asked 2022-09-29T17:28:00.157+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(259.20000000000005, 23%, 35%)' 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)
Sergio Mendoza
1
Reputation point
commented 2025-10-23T07:56:31.37+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(144, 17%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mariano GBEGO
1
Reputation point
1 answer
Empty Files being Placed when using OIC(Oracle Integration Cloud) to copy data into Azure Data Lake
We are currently facing an issue in our UAT environment while copying files from Oracle Integration Cloud (OIC) to Azure Data Lake Gen2 using the OIC connectivity agent installed on an Azure VM inside a secure VNET. Issue Observed When the file copy…
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,499 questions
asked 2025-09-05T07:34:28.1466667+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, 47%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
Dravya Jain
5
Reputation points
commented 2025-10-23T06:34:46.03+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, 16%, 39%)' 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)
Kalyani Kondavaradala
3,145
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
Force Azure Synapse Copy Data to ignore internal GUID
I just added a GUID in an existing table, using ALTER ... and NEWID() as generator. I now have issues updating this table. 1st attempt: When trying to upsert (on another column : client_id) in this table with the source system newest data, I got an error…
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,499 questions
asked 2025-10-21T09:28:04.3133333+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(6.4, 86%, 10%)' 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)
GREGOIRE MANSIO
20
Reputation points
commented 2025-10-22T21:45:46.7566667+00:00
GREGOIRE MANSIO
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Synapse Missing Theme In Settings
Hi, I am new to Azure and had the opportunity to adjust Microsoft products themes to Dark Mode. I was unable to change such theme in Azure Synapse as the option is missing. Looking on the internet there is a Theme option that should be present up top 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,499 questions
asked 2023-04-18T05:26:55.7733333+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(150.4, 96%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
Gabriel Lafreniere
61
Reputation points
commented 2025-10-20T11:47:28.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(76.8, 86%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mohamed Boussaid
0
Reputation points
1 answer
Unable to see the spark pool I have created while configuring the synapse link for dataverse
I have created a spark pool in my synapse workspace to use it for the delta conversion during configuring the synapse link for dataverse for the D365FO data , unfortunately once I choose the synapse workspace and enabled "Use spark pool for delta…
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,499 questions
asked 2024-11-05T11:42:43.1533333+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(195.2, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Athira Reghuraman
95
Reputation points
commented 2025-10-22T20:45:59.81+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, 75%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kristina Punzalan Lee
0
Reputation points
0 answers
Hit unexpected exception, please retry. If the problem persists, please contact Azure Support
Dataflows in Synapse are erroring out with below details. I am also not able to start debug cluster. "errorCode": "145", "message": "Hit unexpected exception, please retry. If the problem persists, please contact Azure…
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,499 questions
asked 2025-09-10T13:46:15.2666667+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(211.20000000000002, 51%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
jg
0
Reputation points
commented 2025-10-16T16:09:52.8033333+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(262.40000000000003, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
VRISHABHANATH PATIL
1,295
Reputation points Microsoft External Staff
Moderator
2 answers
Intermittent Spark Pool Failures and Increased Startup Time After Upgrading to Spark 3.5 in Azure Synapse
We recently upgraded our Synapse Spark pools from version 3.4 to 3.5. As part of the upgrade process, we followed these steps: Removed custom packages from the pools Upgraded the Spark pool version to 3.5 Re-attached the required packages After 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,499 questions
asked 2025-09-22T10:41:50.43+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(6.4, 31%, 10%)' 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)
Nikhil Singh
50
Reputation points
commented 2025-10-22T17:50:44.7033333+00:00
Jesse Horn-Artera
0
Reputation points
1 answer
One-time Data migration from Cosmos DB to Storage Account (data lake) using Azure Synapse Error converting value "MultiHash" to type 'Microsoft.Azure.Documents.PartitionKind'
Hello, I'm trying to perform a data migration from CosmosDB to Storage Account, but on the mapping step, I'm facing the following issue: Error converting value "MultiHash" to type 'Microsoft.Azure.Documents.PartitionKind'. Path…
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,499 questions
asked 2025-10-13T21:32:23.0566667+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(41.6, 34%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
Galin Jelev
0
Reputation points
commented 2025-10-16T14:07:05.8333333+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, 72%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Swapnesh Panchal
740
Reputation points Microsoft External Staff
Moderator
1 answer
Which is faster copy command vs bulkinsert/polybase in copy activity (synapse)?
Dear all, Could you please help me explaining which is faster to use copy command vs bulk insert /poly base in copy activity while pushing data to sink? Thanks, Mahasweta
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,499 questions
asked 2025-10-15T09:34:19.5833333+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(316.8, 50%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Das, Mahasweta
20
Reputation points
commented 2025-10-16T10:25:05.92+00:00
Manoj Kumar Boyini
330
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
Why Does My Azure Synapse Analytics Pipeline Keep Failing with Data Loading Errors?
I’m working on an Azure Synapse Analytics pipeline (dedicated SQL pool, 200 DWUs) to load sales data from Azure Blob Storage (CSV files with columns OrderID, Product, Revenue) into a data warehouse for business reporting. The pipeline uses Copy…
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,499 questions
![](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(19.2, 60%, 11%)' 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)
1 answer
One of the answers was accepted by the question author.
How well does R work in Synapse Analytics Notebooks?
Hello, According to the documentation (https://free.blessedness.top/en-us/azure/synapse-analytics/spark/apache-spark-r-language), Synapse Analytics Notebooks support an R runtime as part of the Spark environment. I’d like to clarify whether it’s possible…
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,499 questions
asked 2025-10-22T12:43:19.06+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(92.8, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Palacio-Gomez Fernando
20
Reputation points
accepted 2025-10-22T13:18:54.0733333+00:00
Palacio-Gomez Fernando
20
Reputation points