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 Link Not Syncing Updates from Dataverse to ADLS — Inserts Work Fine
Environment Dataverse (Dynamics 365) → ASL → ADLS Gen2 → Databricks → EDW Sync interval: 30 minutes Change Tracking: Enabled on all affected tables Issue We are using Azure Synapse Link to sync Dataverse tables to ADLS Gen2. We have a recurring…
Azure Synapse Analytics
Not able to delete Azure Synapse Analytics resource
Hello Microsoft team, I am not able to delete Azure Synapse Analytics resource from UAT and PRD Azure subscription. I am getting an error as - An error has occured while deleting the resource.
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.
livy session
getting this error tried multiple times LIVY_JOB_STATE_DEAD: Livy session has failed. Session state: Dead. Error code: LIVY_JOB_STATE_DEAD. Job failed during run time with state=[dead]. Source: Unknown.
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 pool external table failure with COPY schema discovery error after restart
Hello, We encountered an issue where external Parquet-based tables in a dedicated SQL pool started failing with the following error: COPY statement input file schema discovery failed: Cannot process the file https://
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.
New Requirements to Spark Pool via EV2
I have been facing some issues with deploying new requirements to a Synapse Spark Pool. We currently deploy our Synapse pool requirements via EV2. When I try to add a new module to the requirements.json file (in this case, azure.cosmos), it fails during…
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.
The Synapse job is stuck while reading a large number of ADLSv2 files
workspace: edp-synapse-cpccogs-prod spark pool: cpccogs SparkJobDefinition_412adb40-2985-4d64-93a4-e06e59bd9a2d; livy id: 4538 SparkJobDefinition_463e4caf-1a3e-4949-9fd3-330c0b343295; livy id:…
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: SQL Database not affected?
We also received the email, mentioned in this question: Transition your Azure Synapse Analytics workspaces to private links before 1 August 2026 In the email only Azure Key Vault and Azure Blob Storage are mentioned. Are only those two affected by 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 recreate Synapse workspace 24+ hours after delete: name still reserved (WorkspaceNameUnavailable)
Issue After successfully deleting an Azure Synapse Analytics workspace, the workspace name remains reserved for 24+ hours, preventing recreation with the same name. check-name returns available: false and recreate via Terraform fails with…
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 to Public SFTP from Azure Synapse – Linked Service HMAC Error and Python Connection Timeout
Problem Statement We have a requirement to read and write data to a cloud/on‑prem SFTP server from Azure Synapse. The SFTP server (sftpssh.example.com) is a public SFTP server. We are using Azure Synapse with a Self‑Hosted Integration Runtime…
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 Delete Spark Pool
I am trying to delete a spark pool from a workspace but I am unable to. I have verified that this Spark pool is no longer referenced by any notebooks, pipelines, or historical workloads, and all known dependencies have been removed or reassigned. Despite…
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.
Change Spark Pool Version in Synapse Analytics
Hi Guys, i hope you are good! I have a Synapse Env with a lot of Spark Pools with spark version 3.4. I need to change the pools to the version 3.5, we have a path to do this easier? I search in the documents and in the AI but i just saw that i can do…
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.
Unbale to run synapse pipeline when triggered from ADF, but runs inside synapse just fine.
We have two Synapse pipelines inside our synapse resource which runs fine when triggered from synapse, but when triggered from ADF, they fail with the below error: Error details This application failed due to the total number of errors: 1. Error code 1…
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 following Error: Query failed because of connection issues to control container or control container failure.
I have a Synapse Lake Database what has tables which were created on csv files stored in adls gen2, Everything has been working fine until now. Every time I execute a specific query in SSMS or SQL Query of Synapse I get the following error message:…
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
Is there a way to enable a managed private network in an existing Azure Synapse workspace where it hasn’t been enabled? We recently received an email about transitioning to private links before August next year, otherwise Synapse will lose its ability 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.
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.
Options to migrate from Synapse for Spark Data Ingestion Jobs
Hi All, My team is currently trying to migrate from Synapse for our Spark Data Ingestion Job where we ingest data from Kusto clusters via Service Principal and store since the recommendation is to migrate to newer solutions which are actively being…
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.
Notebook execution is hanging when triggered using synapse pipeline
My spark notebook is extracting data from data lake & is triggered through notebook activity from a synapse pipeline, it was working fine till 27th April, execution started hanging after that for long time, when executed manually notebook executes…
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.
Regarding version of azure synapse analysis
Regarding this swatsynapse workspace we are seeing the latest version but we are still receiving the mail'
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.
quotas and resources constraints in apache spark for azure synapse
quotas and resources constraints in apache spark for azure synapse
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.
Deployment issue in Azure Synapse Analytics
Context We are using: Azure Synapse Analytics Git integration with main as collaboration branch Synapse Publish to generate: TemplateForWorkspace.json TemplateParametersForWorkspace.json Azure DevOps release pipeline with the Synapse workspace…
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.