5,432 questions with Azure Synapse Analytics tags

Sort by: Updated
1 answer

What is the firewall port for Microsoft Access connect with Azure Synapse Workspace and Synapse SQL Serverless Pool?

Hi, I am trying to connect Microsoft Access from local desktop to the Cloud Azure Synapse SQL Serverless Pool, and the port 1433 should be the default one for connection. But when we are trying to search for answer from the internet, there're someone…

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,432 questions
asked 2025-08-29T00:35:11.5933333+00:00
Jason Wong 0 Reputation points
answered 2025-08-29T06:18:04.7466667+00:00
TP 134.2K Reputation points Volunteer Moderator
2 answers

Azure Synapse pipeline fails with 'invalid_client_id' despite successful test connection

I'm encountering a frustrating issue with my Azure Synapse pipeline. My pipeline fails with an 'invalid_client_id' error when a copy activity attempts to write to a Salesforce sink using Client ID/Secrets during Azure Synapse Salesforce Cloud System…

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,432 questions
asked 2025-08-28T13:49:46.2566667+00:00
MURAS Miro 21 Reputation points
accepted 2025-08-28T22:57:53.1766667+00:00
MURAS Miro 21 Reputation points
2 answers

ADF can not parse Parquet files

I have a pipeline that consist copy data activity like following; I installed OpenJDK on all servers where we use our Integration Runtime. But still, I get error like the following; { "errorCode": "2200", …

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,432 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,794 questions
asked 2022-11-24T08:21:06.88+00:00
Melih Kavraz 1 Reputation point
commented 2025-08-28T22:38:13.99+00:00
Najeebullah Hussaini 0 Reputation points
1 answer

Scaling up Synapse Dedicated Pools taking a long time

Scaling up Synapse Dedicated Pools is taking more than an hour

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,432 questions
asked 2025-08-26T14:12:21.4033333+00:00
Anthony Perkins 0 Reputation points
edited a comment 2025-08-28T17:22:40.1466667+00:00
Anthony Perkins 0 Reputation points
1 answer

Recommended Step by Step to Rename Azure Synapse Pool

New to Azure Synapse Workspace and pools. DBA's are trying to find a process to restore database from prod into dev. So for example, can set a restore point, can restore. The issue, trying to determine how to rename the pool so that things that rely…

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,432 questions
asked 2022-03-09T15:59:29.347+00:00
Smileyville 1 Reputation point
commented 2025-08-28T16:48:17.77+00:00
da_crusher 1 Reputation point
1 answer

Hot fix create button not finish loading for Dedicated SQL Pool (formerly SQL DW)

Create Button in Dedicated SQL Pool is Stuck on Loading. I have tried also switching internet and trying in incognito mode and still won't work.

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,432 questions
asked 2025-08-20T11:57:31.4433333+00:00
Dragos Marinescu 0 Reputation points
commented 2025-08-28T09:13:37.4966667+00:00
VRISHABHANATH PATIL 85 Reputation points Microsoft External Staff Moderator
1 answer

Issue with Write-Back to Legacy System via ODBC Connection in Azure synapse

Hi, I'm attempting to perform a write-back operation to a table in a legacy system using an ODBC connection. The DSN is configured in ODBC mode, which supports both read and write operations. We’re able to preview the data successfully using 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,432 questions
asked 2025-08-21T13:04:41.22+00:00
Harikrishnan Arayakeel 0 Reputation points
commented 2025-08-27T07:34:54.93+00:00
Harikrishnan Arayakeel 0 Reputation points
1 answer

How to connect Azure Synapse with Sharepoint server

How to connect/create Linked Service between Azure Synapse to Sharepoint server

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,432 questions
asked 2025-08-22T07:42:25.69+00:00
Pushkal Nandan (A) 0 Reputation points
commented 2025-08-26T03:22:08.04+00:00
Pratyush Vashistha 1,525 Reputation points Microsoft External Staff Moderator
1 answer

Excel file ingestion failing with error code 21359 in Synapse – file not password protected

We are encountering an issue when trying to connect and preview data from an Excel file (errorapache.xlsx) in Azure Synapse Analytics. The pipeline fails with the following error: Error code: 21359 Details: Encrypted excel file 'errorapache.xlsx' is…

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,432 questions
asked 2025-08-20T08:38:27.8633333+00:00
Routine User 6 Reputation points
commented 2025-08-26T03:16:24.5+00:00
Pratyush Vashistha 1,525 Reputation points Microsoft External Staff Moderator
1 answer

High availability of Synapse dedicated SQL pool within a region

We have provisioned a Synapse dedicated SQL pool for our business. We need to make sure that the service is highly available within the region. This means we cannot have the data be moved to another region but need to make sure that the DWH is available…

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,432 questions
asked 2024-06-26T03:42:13.2066667+00:00
Chand, Anupam SBOBNG-ITA/RX 466 Reputation points
commented 2025-08-25T09:18:16.8966667+00:00
Janne Kujanpää 261 Reputation points
1 answer

How to migrate the data from Teradata to Azure Synapse in batch mode with low network latency

How to migrate the data from Teradata to Azure Synapse in batch mode with low network latency

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,432 questions
asked 2025-08-22T05:03:58.0133333+00:00
Vasudev Sriramula (INFOSYS LIMITED) 0 Reputation points Microsoft External Staff
answered 2025-08-22T13:12:35.8433333+00:00
VRISHABHANATH PATIL 85 Reputation points Microsoft External Staff Moderator
1 answer

Azure Synapse Workspace Capacity Error

We were using small sized core setup on our Synapse Analytics and we are trying to process 5GB data and it is taking more time, Hence we trying to maximize the core size , but unable to do so. Can some one help increase quota for us.

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,432 questions
asked 2025-08-21T12:37:06.35+00:00
Vairamani Annamalai 55 Reputation points
commented 2025-08-21T13:39:03.18+00:00
Smaran Thoomu 29,415 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Issue with Dynamic List Name in SharePoint to Azure DataLake Synapse Pipeline

Hello, I’m currently working on building a data pipeline to copy SharePoint Online list data into Azure DataLake. The pipeline uses a Lookup activity to retrieve the list names and a Copy activity within a ForEach loop to process each list. The pipeline…

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,432 questions
asked 2025-08-13T08:11:48.89+00:00
Sakshi Deshpande 20 Reputation points
accepted 2025-08-20T07:31:48.56+00:00
Sakshi Deshpande 20 Reputation points
1 answer One of the answers was accepted by the question author.

Apache Spark poll ends with time out error

Hi, When runninn my pipeline which contains a Notebook activity, I faced this error. This error appears suddenly sometimes, and sometimes doesn't happend This pipeline executes iteratively almost 15 times, for the same Notebook which is parametrized. 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,432 questions
asked 2025-08-07T15:41:45.63+00:00
Jona 925 Reputation points
accepted 2025-08-19T20:48:56.94+00:00
Jona 925 Reputation points
1 answer

How to read a csv file from synapse link service to a storage data lake

I am trying to use pyspark via synapse to read a table/csv file that resides on a storage account. I have got the code below, but 2 things. Its failing due to access and i am not sure if the syntax is correct wither. I have got a synapse spark pool and…

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,432 questions
asked 2025-08-07T15:52:16.0633333+00:00
MrFlinstone 706 Reputation points
commented 2025-08-18T05:17:25.99+00:00
Pratyush Vashistha 1,525 Reputation points Microsoft External Staff Moderator
1 answer

An error occurred during execution: Error: Get workspace location error: Could not fetch access token for Azure. Verify if the Service Principal used is valid and not expired.

Can anybody help this one i was getting this issue : 2025-08-12T05:17:07.7528279Z ##[section]Starting: Synapse: DEPLOY (templates) 2025-08-12T05:17:07.7532471Z…

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,432 questions
asked 2025-08-12T06:26:11.8266667+00:00
Boyapati haribabu 0 Reputation points
commented 2025-08-15T04:26:29.66+00:00
Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Data flow / Derived column doesn't see columns names - 'Column not found'

Hello, I am working with Derived Columns in Data Flow within Azure Synapse Analytics for the first time and am encountering some issues. Despite following tutorials and conducting simple tests, I receive an error message stating "Column not…

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,432 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,794 questions
asked 2025-02-10T17:03:05.9166667+00:00
Andrzej 25 Reputation points
commented 2025-08-14T09:33:13.6133333+00:00
Liam McDermott 0 Reputation points
1 answer

Error when running debug on a pipeline in synapse

I have got a sink destination for a synapse analytics pipeline, works well with the storage account setup with synapse, however I am trying to change the sink destination to a different storage account, anytime I do that and run the pipeline in debug…

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,432 questions
asked 2025-08-07T11:00:22.8066667+00:00
MrFlinstone 706 Reputation points
commented 2025-08-11T11:52:01.1133333+00:00
Venkat Reddy Navari 5,815 Reputation points Microsoft External Staff Moderator
1 answer

I passed a certification registered under Microsoft account. How can I download the certificate when this account was closed?

Hi, there I passed a certification registered under Microsoft account. I signed in with Microsoft account to book the exam and passed it. Now this account was closed and I can no longer to sign in with it, I don't have access to the certificate. How can…

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,432 questions
asked 2025-08-10T13:45:46.98+00:00
Peng Lyu 0 Reputation points
answered 2025-08-10T14:09:36.7933333+00:00
Andreas Baumgarten 126K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Azure Synapse API call 403 error when accessing Synapse Notebook with GET method

{ "error": { "code": "Unauthorized", "message": "The principal '71b82c6f-3c4b-4060-a695-61e366d4f5f8' does not have the required Synapse RBAC permission to perform this action. Required…

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,432 questions
asked 2024-03-07T17:01:28.5066667+00:00
Vivek Vijay Patil 40 Reputation points
accepted 2025-08-09T18:57:12.6666667+00:00
Vivek Vijay Patil 40 Reputation points