An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
How to below error for Synapse Linked service connection
Spark job failed: { "text/plain":…
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.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
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
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.