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,652 questions
2 answers
Changelog folder created by Synapse Link
Hi, Synapse Link is writing timestamped folders to Blob Storage from D365 as expected. The documentation states that consumers should not process the folder currently referenced in the changelog file. I would like to clarify the behavior of files within…
Azure Synapse Analytics
asked 2026-06-09T05:06:22.91+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EDN%3C/text%3E%3C/svg%3E)
Deshmukh, Niyati
40
Reputation points
commented 2026-06-12T03:00:50.0366667+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EPP%3C/text%3E%3C/svg%3E)
Pilladi Padma Sai Manisha
9,945
Reputation points Microsoft External Staff
Moderator
2 answers
EntitySyncFailure: Could not find stored procedure SP_CDSVirtualEntityGetPageRangesV2 for Synapse Link for Dataverse D365FO
Our team was able to create Synapse Link for Dataverse D365FO select tables to sync. However now I have noticed all the tables are empty in synaspe workspace and the EntitySyncFailure folder is populated with logs of each entity having a message similar…
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,652 questions
asked 2026-06-03T21:07:30.8366667+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EAO%3C/text%3E%3C/svg%3E)
Alexander O'Reilly
40
Reputation points
commented 2026-06-11T03:02:41.7066667+00:00
Pilladi Padma Sai Manisha
9,945
Reputation points Microsoft External Staff
Moderator
2 answers
one of the pipeline is failing while saving the data back with spark context was closed
I am getting an error saying spark context was closed , it's taking an hour to run the pipeline and then it's failing because the spark context was closed . I am attaching the screenshot of the error and also the link to the logs : …
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,652 questions
asked 2026-06-09T15:40:11.3833333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EAT%3C/text%3E%3C/svg%3E)
Anuradha Tiwary
0
Reputation points
commented 2026-06-10T21:09:00.5833333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ESJ%3C/text%3E%3C/svg%3E)
SAI JAGADEESH KUDIPUDI
3,385
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Synapse Pipeline and Spark Job Delays across West US2 and East US2, from 5/28 11PM to 5/29 1AM
Hi Synapse supporting: We found large amount of pipeline runs and spark jobs created from 5/28 11PM to 5/29 1AM were stuck for 6 to 24 hours. These jobs resumed randomly after long delays. This issue happened across all of our Synapse workspaces in…
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,652 questions
asked 2026-05-29T18:41:21.0133333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ECH%3C/text%3E%3C/svg%3E)
Christine Han
140
Reputation points Microsoft Employee
accepted 2026-06-10T05:58:46.11+00:00
Christine Han
140
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Synapse Link: Changing Incremental Update Folder Structure time interval Azure Synapse Link
Hello, I have a synapse link to put data from D365 F n O to blob storage. The time interval for the folder structure was previously 60 minutes and I changed it to 720 minutes in the existing synapse link (no other changes, same container, tables 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,652 questions
asked 2026-06-02T13:29:44.9533333+00:00
Deshmukh, Niyati
40
Reputation points
accepted 2026-06-09T04:57:53.9233333+00:00
Deshmukh, Niyati
40
Reputation points
1 answer
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,652 questions
asked 2023-04-18T05:26:55.7733333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EGL%3C/text%3E%3C/svg%3E)
Gabriel Lafreniere
61
Reputation points
commented 2026-06-08T23:24:02.9033333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EQL%3C/text%3E%3C/svg%3E)
Qingnan Liu
0
Reputation points
1 answer
System-managed MPE 'synapse-ws-sqlOnDemand--<workspace>' stuck in Rejected state
Environment Azure Synapse Analytics workspace (serverless SQL pool only — no dedicated SQL pool) Managed Virtual Network: Enabled Data Exfiltration Protection (DEP): Enabled Public network access: Disabled Region: Central US Problem 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,652 questions
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ER%3C/text%3E%3C/svg%3E)
1 answer
Does Microsoft give option to create new Ticket ?
How to generate new ticket in Azure portal? It was available earlier but now Microsoft is redirecting to documents or other Q&A pages and not letting me create new ticket.
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,652 questions
asked 2026-06-04T10:42:16.32+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ETF%3C/text%3E%3C/svg%3E)
Talha Farooqi
0
Reputation points
commented 2026-06-07T05:36:07.39+00:00
Pilladi Padma Sai Manisha
9,945
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
Synapse workspace stuck in Failed provisioning state ; preserve existing artifacts (no delete)
Issue summary Synapse workspace entered Failed provisioning state after a workspace write operation failed. Subsequent update attempts fail with: ValidationFailed WorkspaceInNonTerminalState Workspace is in non-terminal state Failed and cannot…
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,652 questions
asked 2026-06-01T07:36:51.3466667+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EDH%3C/text%3E%3C/svg%3E)
Divesh Harisinghani
20
Reputation points Microsoft Employee
accepted 2026-06-04T12:18:22.58+00:00
Divesh Harisinghani
20
Reputation points Microsoft Employee
0 answers
synapse: tumbling trigger stopped firing
starting today, between 6am~ongoing, tumbling trigger stopped firing. even after recreating the trigger, it does not fire.currently manually triggered to unblock icm, but this won't last long. this blocked production job.
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,652 questions
asked 2026-05-30T18:16:46.6433333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ESK%3C/text%3E%3C/svg%3E)
Sean Kang
0
Reputation points Microsoft Employee
commented 2026-05-31T10:21:26.8933333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ESS%3C/text%3E%3C/svg%3E)
Sina Salam
29,846
Reputation points
Volunteer Moderator
1 answer
How can I update Synapse Workspace's Azure SQL Auditing connection to Storage Account to use Managed Identity
Hello, I am attempting to update the Azure SQL Auditing connection to use Managed Identity instead of Storage Access Key. Following the documentation online, when I'm in the Azure SQL Auditing settings I should see both an option for Managed Identity 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,652 questions
asked 2026-05-26T23:11:07.43+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EVB%3C/text%3E%3C/svg%3E)
v-bemat
0
Reputation points Microsoft External Staff
commented 2026-05-29T21:46:43.8966667+00:00
SAI JAGADEESH KUDIPUDI
3,385
Reputation points Microsoft External Staff
Moderator
1 answer
We are observing an issue with our Synapse Spark pool where both streaming and batch jobs are getting stuck and not making progress.
Streaming jobs: Jobs continue running beyond configured --running-duration-seconds (9600) No observable progress during this period Jobs do not self-recover, restarting Spark node pool fixes the issue Batch jobs: Python batch jobs are timing…
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,652 questions
asked 2026-05-27T15:01:38.97+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ESG%3C/text%3E%3C/svg%3E)
Shivam Gupta
0
Reputation points Microsoft Employee
answered 2026-05-28T14:21:30.3266667+00:00
Sina Salam
29,846
Reputation points
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Transition Azure Synapse Analytics workspaces to private links before 1 August 2026
We have a few questions regarding the Synapse transition to private links: Identifying impacted workspaces What is the recommended approach to identify which Synapse workspaces or environments are actually impacted? Customers are receiving 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,652 questions
asked 2026-05-21T10:16:48.7933333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EAN%3C/text%3E%3C/svg%3E)
Ahmad Nafouri
45
Reputation points
commented 2026-05-27T13:49:06.9833333+00:00
Ahmad Nafouri
45
Reputation points
2 answers
mssparkutils.credentials.getToken() does not support CognitiveServices or AIServices audience aliases — no way to acquire SAMI token for Azure OpenAI or Azure AI Foundry from Spark notebook.
We are migrating Synapse Spark pipeline authentication from certificate-based Service Principal to workspace System-Assigned Managed Identity (SAMI) to comply with SFI. The SAMI has been granted the required RBAC roles (Cognitive Services OpenAI…
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,652 questions
asked 2026-05-23T23:04:22.71+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ELW%3C/text%3E%3C/svg%3E)
Lilu Wan
0
Reputation points Microsoft Employee
commented 2026-05-27T13:02:26.46+00:00
Sina Salam
29,846
Reputation points
Volunteer Moderator
0 answers
Join: Microsoft Azure Q&A Champions Program
The Microsoft Azure Q&A Champions Program recognizes and empowers a global community of internal and external Azure experts who help customers succeed by providing high-quality, trusted answers on Microsoft Q&A. The program scales expert led…
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,652 questions
asked 2026-05-25T23:49:30.21+00:00
Ashley Swearingen
0
Reputation points Microsoft External Staff
Moderator
answered 2026-05-25T23:49:39.34+00:00
AI answer
1 answer
Error details Error details ResourceInUnupdatableState Target Spark pool specified in Spark job definition is not in succeeded state. Current state: Provisioning
Was doing deployment of spark spool thorugh CICD for synapse. Failure happened and keep saying the spool is in Provisioning 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,652 questions
asked 2026-05-20T09:34:59.0233333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EJL%3C/text%3E%3C/svg%3E)
Johnny Lam
0
Reputation points Microsoft Employee
answered 2026-05-25T03:02:12.2466667+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
35,375
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Unable to list or secret certificate in Azure Synapse Linked service
Hi Team, We have a linked service to Azure Key Vault and used 'User-assigned managed identity' as Authentication Method. Also, we have another linked service to Azure SQL Database and used this Key Vault linked service. When we test the connection, we…
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,652 questions
asked 2026-05-18T12:17:12.26+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ESB%3C/text%3E%3C/svg%3E)
Sudhakar Buddepu
20
Reputation points Microsoft External Staff
accepted 2026-05-21T09:23:13.5666667+00:00
Sudhakar Buddepu
20
Reputation points Microsoft External Staff
2 answers
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
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,652 questions
asked 2026-05-13T18:01:24.42+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EMC%3C/text%3E%3C/svg%3E)
Michael Clemans
140
Reputation points
commented 2026-05-21T09:07:40.2733333+00:00
Smaran Thoomu
35,375
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Request assistance to validate Service Health Activity Log Alert for BCDR automation
We have implemented an automated BCDR mechanism for our Azure Synapse Analytics workloads. The solution uses an Activity Log Alert (type: microsoft.insights/activityLogAlerts) configured to fire when a Service Health incident is reported for 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,652 questions
asked 2026-05-19T09:52:55.37+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3EMD%3C/text%3E%3C/svg%3E)
Mahendra Dhawse (INFOSYS LIMITED)
20
Reputation points Microsoft External Staff
accepted 2026-05-21T05:46:53.9033333+00:00
Mahendra Dhawse (INFOSYS LIMITED)
20
Reputation points Microsoft External Staff
2 answers
One of the answers was accepted by the question author.
Synapse data-plane notebook publish consistently returns 500 NullReferenceException in NotebookCrudManager (test tenant, westus3)
Problem Every PUT against the Synapse data-plane notebook API for workspace instance returns 500 Internal Server Error with a NullReferenceException in NotebookCrudManager, regardless of notebook content, body shape, calling identity, or storage…
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,652 questions
asked 2026-05-18T04:15:31.6833333+00:00
'%20cx='32'%20cy='32'%20r='32'%20/%3E%3Ctext%20x='50%25'%20y='55%25'%20dominant-baseline='middle'%20text-anchor='middle'%20fill='%23FFF'%20%3ESA%3C/text%3E%3C/svg%3E)
Sneha Alwani
20
Reputation points Microsoft Employee
answered 2026-05-18T05:53:21.93+00:00
Pilladi Padma Sai Manisha
9,945
Reputation points Microsoft External Staff
Moderator