5,590 questions with Azure Synapse Analytics tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

Our Azure Synapse workspace "lsd850-synapse01" is stuck in provisioningState=Failed following a full subscription tenant transfer

Our Azure Synapse workspace "lsd850-synapse01" is stuck in provisioningState=Failed following a full subscription tenant transfer (Transfer Service Administration = YES). Current behavior: - Runtime execution works: existing pipelines 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,590 questions
asked 2026-03-10T14:01:35.4633333+00:00
Ron Radkay 20 Reputation points
accepted 2026-03-12T17:56:48.9366667+00:00
Ron Radkay 20 Reputation points
2 answers

Export Synaps Notebook from my development branch

Hi, Is there an automated way to export Notebook from a specific Azure DevOps branch as ipynb file to the local machine?. Thanks for your help. Kind regards

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,590 questions
asked 2023-04-21T13:29:30.77+00:00
VT 1 Reputation point
edited a comment 2026-03-12T16:23:45.9266667+00:00
Doug Ivison 16 Reputation points
1 answer

SftpFailedToConnectToSftpServer

I’m trying to connect to an SFTP server from Azure Synapse using a Self-Hosted Integration Runtime (SHIR), but I'm having trouble. I received the following error: Error code: SftpFailedToConnectToSftpServer Details: Failed to connect to SFTP 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,590 questions
asked 2026-03-05T15:55:30.7866667+00:00
Maverick 0 Reputation points
commented 2026-03-12T13:50:17.2133333+00:00
Maverick 0 Reputation points
2 answers One of the answers was accepted by the question author.

Azure Synapse Pipeline hard limit

Hello Team, This is something that I have asked the Azure Synapse community and would like to know if it is still the same or if things have changed. We have a requirement to migrate multiple systems in to Synapse. We understand that the hard limit on…

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,590 questions
asked 2026-01-21T14:57:25.7133333+00:00
Parameswaran Serussery Narayanan 155 Reputation points
commented 2026-03-12T11:35:22.2066667+00:00
Parameswaran Serussery Narayanan 155 Reputation points
1 answer One of the answers was accepted by the question author.

how to upgrade the apache spark version in Azure Synapse workspace

How to upgrade the apache spark version in Azure Synapse workspace. The security group mentioned apache spark version of 3.4 will be retired soon, we need to upgrade it from 3.4 o 3.5 in all related apache spark pools. How can we do that?

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,590 questions
asked 2026-03-12T08:33:41.4866667+00:00
Vincent Hao (Beyondsoft Corporation) 0 Reputation points Microsoft External Staff
commented 2026-03-12T09:04:02.63+00:00
Vincent Hao (Beyondsoft Corporation) 0 Reputation points Microsoft External Staff
1 answer

How to Update Data Refresh Interval or Retain Spark Pool Association in Power Apps Azure Synapse Link

We are extracting Dynamics CRM data using Power Apps Azure Synapse Link (ASL) into our Azure Storage Account. The ASL is configured with the required Storage Account, file system, and is linked to an Azure Synapse Analytics workspace. Using an 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,590 questions
asked 2026-03-12T08:53:27.53+00:00
Srimanikanta Pallela 0 Reputation points
answered 2026-03-12T08:53:48.7433333+00:00
Q&A Assist
3 answers

How to below error for Synapse Linked service connection

Spark job failed: { "text/plain":…

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,590 questions
asked 2026-03-04T04:23:18.17+00:00
Karthik Indukuri 0 Reputation points
commented 2026-03-12T06:01:59.6666667+00:00
Smaran Thoomu 33,920 Reputation points Microsoft External Staff Moderator
0 answers

Send Synapse pyspark notebook logs to log analytics workspace

I want to send spark application logs to log analytics workspace and I am following the document here: https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-log-analytics#write-custom-application-logs Is there a way to…

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,590 questions
asked 2026-03-09T06:12:15.2433333+00:00
Suryanarayanan Swetha 0 Reputation points
edited a comment 2026-03-11T10:15:09.3566667+00:00
SAI JAGADEESH KUDIPUDI 485 Reputation points Microsoft External Staff Moderator
0 answers

Deactivate/activate synapse pool to clear the cache

I need to rotate a secret using "ALTER DATABASE SCOPED CREDENTIAL" on my Synapse serverless SQL database. I cannot run that; I get error code 33253 with message 'Failed to modify the identity field of the credential because the credential 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,590 questions
asked 2026-03-10T19:36:23.48+00:00
Kenneth Kabiru 0 Reputation points
edited a comment 2026-03-11T01:15:14.8566667+00:00
Pilladi Padma Sai Manisha 5,240 Reputation points Microsoft External Staff Moderator
1 answer

How to fix Synapse Resource provisioning failed.

After migrating our subscription to a new tenant, the synapse workspace failed due to a missing managed identity. We have reenabled the identity and roles, but the workspace needs to be reset. How can I reset 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,590 questions
asked 2026-03-10T01:50:36.25+00:00
Ron Radkay 20 Reputation points
answered 2026-03-10T07:28:34.9366667+00:00
Smaran Thoomu 33,920 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Cannot create Synapse Analytics Workspace in Uk West

Hi, Are there capacity issues in the Azure Region - UK West or is this specific to our particular subscription/tenant. We can't create a synapse workspace in uk west as it gives this error: Location 'ukwest' is not accepting creation of new Windows 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,590 questions
asked 2026-03-03T10:36:01.1033333+00:00
Richard Carrick 20 Reputation points
accepted 2026-03-06T08:58:00.65+00:00
Richard Carrick 20 Reputation points
2 answers

I need to fetch queued query and casue of temp db utilization

I need to fetch queued query and casue of temp db utilization from the synapse. We have Log Analytics workspaces.

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,590 questions
asked 2026-02-25T22:34:26.76+00:00
shamim 0 Reputation points
commented 2026-03-06T07:40:29.44+00:00
Manoj Kumar Boyini 9,410 Reputation points Microsoft External Staff Moderator
4 answers One of the answers was accepted by the question author.

Issues with Synapse Workflows After Updating Self-hosted Integration Runtime

After updating the Self-hosted Integration Runtime to version 5.54.9267.1 from 5.44.xx on June 10th, the pipeline runs that previously completed in about 30 minutes are now taking several hours and worsening daily. The Integration Runtime operates…

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,590 questions
asked 2025-06-23T13:01:54.3233333+00:00
John Brynford-Jones 31 Reputation points
commented 2026-03-06T07:27:52.34+00:00
Jasper Batterink 15 Reputation points
1 answer

Synapse spark application logs to Az Log Analytics - managed identity

I want to send spark application logs to log analytics workspace and I am following the document here: https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-log-analytics#write-custom-application-logs Is there a way to…

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,590 questions
asked 2024-01-14T21:54:12.43+00:00
_user_unknown_ 6 Reputation points
commented 2026-03-05T11:04:31.7933333+00:00
Suryanarayanan Swetha 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to confirm all spark runtime has been upgraded and meet the new requirements before end of March?

Regarding Azure Synapse Runtime for Apache Spark 3.4 End of Support https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-34-runtime** ** We have been completed the Spark pool upgrade. As we own around 50 Synapse workspaces,…

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,590 questions
asked 2026-03-03T22:32:07.1866667+00:00
Christine Han 80 Reputation points Microsoft Employee
commented 2026-03-04T17:32:10.7066667+00:00
Christine Han 80 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Synapse Serverless SQL – “Cannot find the CREDENTIAL … because it does not exist or you do not have permission” when querying external table

Good morning everyone, We have an issue when we try to query ours tables on SSMS: Cannot find the CREDENTIAL ...because it does not exist or you do not have permission. We had to do our migration for this: Transition your Azure Synapse Analytics…

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,590 questions
asked 2026-02-27T16:57:03.6533333+00:00
Victor Buzy 20 Reputation points
accepted 2026-03-03T21:52:43.02+00:00
Victor Buzy 20 Reputation points
1 answer One of the answers was accepted by the question author.

SparkPool is getting dead after running for a long time in Synapse Notebook

After 1 hour of processing, I just got the following error message: InvalidHttpRequestToLivy: Session XXX of workspace XXX on pool sparkPool is not running. It is either completed or not fully yet ready. Scheduler state : Scheduled. Plugin state :…

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,590 questions
asked 2026-02-24T16:08:08.8566667+00:00
Joao Vitor Mendes da Costa Tinti 20 Reputation points
accepted 2026-03-03T17:46:31.6266667+00:00
Joao Vitor Mendes da Costa Tinti 20 Reputation points
2 answers One of the answers was accepted by the question author.

Synapse Notebook - dynamic name

Surely there must be an answer to this! I want to be able to have a configuration process that decides which notebook should be called in any particular instance - a similar process for configuring ingestion of files - but the notebook entry is 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,590 questions
asked 2021-06-24T23:51:56.903+00:00
Ryan Abbey 1,186 Reputation points
commented 2026-03-03T08:24:44.25+00:00
Nisarg Suthar 0 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

How to handle INT64 values from Parquet when copying to a DateTime column in Azure Synapse using Copy Activity?

I have a Parquet file stored in ADLS. One of the columns in the Parquet file is stored as INT64. When I try to copy this data from ADLS into an Azure Synapse table using Azure Synapse Analytics Copy Activity, I get the following…

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,590 questions
asked 2026-02-28T05:57:04.1166667+00:00
HARISH LOGANATHAN 20 Reputation points
commented 2026-03-03T05:48:55.57+00:00
Smaran Thoomu 33,920 Reputation points Microsoft External Staff Moderator
1 answer

Transition your Azure Synapse Analytics workspaces to private links before 1 August 2026

Hello, We received an email from Microsoft saying that "Transition your Azure Synapse Analytics workspaces to private links before 1 August 2026" We discovered that our current synapse workspace does not have Managed VNet. Creating a new…

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,590 questions
asked 2026-02-24T15:33:09.5433333+00:00
Victor Buzy 20 Reputation points
commented 2026-03-01T10:55:04.62+00:00
Smaran Thoomu 33,920 Reputation points Microsoft External Staff Moderator