5,570 questions with Azure Synapse Analytics tags

Sort by: Updated
1 answer

Azure synapse analytics there are showing but not able to find the exact resource

We are seeing that azure synapse upgrade in the query but it is not showing any resource name, could you please help how to find the exact resource

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,570 questions
asked 2026-02-04T06:09:05.23+00:00
NAVEEN Mittal 45 Reputation points Microsoft External Staff
answered 2026-02-04T06:09:13.3733333+00:00
Q&A Assist
2 answers One of the answers was accepted by the question author.

How to publish Synapse workspace with Pull Request generated

We are using Git integration to publish workspaces templates to workspace_publish branch. We recently received S360 item regarding the commitWithoutPullRequest voliation from AzDO Production Readiness Check. Please suggest how to generate PR for the git…

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,570 questions
asked 2026-01-30T00:36:49.34+00:00
Christine Han 40 Reputation points Microsoft Employee
accepted 2026-02-04T05:37:13.5+00:00
Christine Han 40 Reputation points Microsoft Employee
3 answers

How to fix - Error: The resource type 'Microsoft.Synapse/workspaces/kustoPools' is not found.

Hi Team, We are suddenly encounter error "Error: The resource type 'Microsoft.Synapse/workspaces/kustoPools' is not found." in our workspace.No configuration changes have been made on our end Please guide us to resolve this issue

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,570 questions
asked 2026-01-23T08:11:03.39+00:00
Nitya V 175 Reputation points
edited a comment 2026-02-04T05:36:07.7166667+00:00
Christine Han 40 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

more frequent “insufficient resource” errors when starting new notebook sessions

We observed more frequent “insufficient resource” errors when starting new notebook sessions in our West US 2 workspace. In these cases, the notebook start-up hangs for several hours, while the pipeline status wasshow “In Progress” instead of failing. …

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,570 questions
asked 2026-01-02T20:44:29.58+00:00
Christine Han 40 Reputation points Microsoft Employee
edited a comment 2026-02-04T05:26:29.42+00:00
Christine Han 40 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

How to fix Azure Synapse Linked Service TCPS SSL Handshake Failure to Oracle Database via Self-Hosted Integration Runtime ?

We are experiencing an SSL handshake failure when testing a connection from Azure Synapse Analytics to an Oracle Database over TCPS using a Self-Hosted Integration Runtime (SHIR). The Oracle database listener is configured for TCPS, and the 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,570 questions
asked 2026-02-02T09:39:45.67+00:00
Bledi Toçka 20 Reputation points
commented 2026-02-03T11:41:27.6333333+00:00
Pilladi Padma Sai Manisha 3,210 Reputation points Microsoft External Staff Moderator
4 answers

How to download files(>4mb) USING copy activity from REST END POINT in synapse.

I am trying to download files from REST end points using a) web activity for token generation and passing token to copy activity. b) copy activity for downloading the files. source is BINARY and sink is binary. I am able to download the file sizes up…

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,570 questions
asked 2026-01-28T02:59:57.6+00:00
Vijay Tetali 0 Reputation points
commented 2026-02-03T08:51:15.97+00:00
Pilladi Padma Sai Manisha 3,210 Reputation points Microsoft External Staff Moderator
2 answers

Dedicated SQL Pool is taking a long time scale up and down

Dedicated SQL pool is taking 20 - 30 minutes to scale up and down. Average time prior to Jan 16 was 10 minutes or less. This is impacting production performance. As a side note, we had this issue last year and it was resolved. What was fixed seems 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,570 questions
asked 2026-02-02T17:31:09.68+00:00
Doreen Cecil 20 Reputation points
commented 2026-02-02T17:37:33.07+00:00
Manoj Kumar Boyini 5,410 Reputation points Microsoft External Staff Moderator
1 answer

Synapse Mapping Data Flow Sink creates unexpected empty 0-byte files when writing Parquet to Azure Blob Storage

Issue Summary : When using Azure Synapse Analytics Mapping Data Flow to write an updated Parquet file from one Blob Storage container to another, the Sink creates: The expected Parquet file inside the correct folder structure : …

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,570 questions
asked 2026-02-02T15:23:04.52+00:00
Shinde, Dushyant 0 Reputation points
answered 2026-02-02T15:58:10.3133333+00:00
Pilladi Padma Sai Manisha 3,210 Reputation points Microsoft External Staff Moderator
1 answer

Script run failed in synapse notebook to read data from CosmosDB when upgrade to spark pool 3.5

script run failed when upgrade to spark pool 3.5 with the script below: df = spark.read.format("cosmos.olap")\ .option("spark.synapse.linkedService", linkservice)\ .option("spark.cosmos.container",…

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,570 questions
asked 2026-01-15T22:17:21.21+00:00
Long Wen 1 Reputation point Microsoft Employee
commented 2026-02-02T05:50:01.4933333+00:00
VRISHABHANATH PATIL 5,175 Reputation points Microsoft External Staff Moderator
1 answer

Issue: [REDACTED] appears in CSV column names in Azure Synapse (ACC only)

We observe inconsistent behavior between environments when reading CSV files from ADLS Gen2 in Azure Synapse Analytics (Spark). In TST, column names are read correctly, for example: MYS Work Type To Invoice$77889ad3-1296-4344-a858 In ACC only, parts of…

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,570 questions
asked 2026-01-29T15:01:26.64+00:00
Emma van Rhijn 0 Reputation points
commented 2026-02-02T03:50:42.1033333+00:00
Manoj Kumar Boyini 5,410 Reputation points Microsoft External Staff Moderator
1 answer

Azure Synapse link tables stuck in a "Queued" or "Initial sync in progress" status when syncing to Azure storage. How can I fix these tables to sync fully?

HI, I have set up Azure Synapse link (for Finance and Operations) and successfully sync'd a number of tables to my Azure Storage account. Some, not all, tables are stuck in a "Queued" or "Initial sync in progress" status when…

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,570 questions
asked 2025-09-02T12:21:00.4666667+00:00
Kevin Masterson 0 Reputation points
commented 2026-02-01T13:37:02.1233333+00:00
Michael Barnett 0 Reputation points
1 answer One of the answers was accepted by the question author.

Access Control in Synapse Dedicated SQL Pool and Impact of Notebooks

Hello, I am looking for some critical information related to data security aspect within the Synapse. Below is our current scenario, We have a Synapse dedicated sql pool in the production environment. The dedicated sql pool has multiple schemas of which…

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,570 questions
asked 2025-11-11T23:18:08.97+00:00
Parameswaran Serussery Narayanan 155 Reputation points
commented 2026-02-01T09:59:27.1466667+00:00
Vinodh247 41,061 Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Multi process inbound file ingestion process

Hello, I am looking for some pipeline design recommendations. We have multiple process (20+) that are currently being reviewed for migration to Synapse. These process are based on inbound files and once the files are processed to the data lake store or…

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,570 questions
asked 2026-01-22T10:26:00.3933333+00:00
Parameswaran Serussery Narayanan 155 Reputation points
accepted 2026-01-29T20:22:29.4833333+00:00
Parameswaran Serussery Narayanan 155 Reputation points
2 answers

Synapse failure with Internal error

Hello - We have two days our processes on Synapse analytics is failing with internal error. Is failing to extract data from Oracle OCI. This is the error message: "Operation on target FA-DWH-MAIN-FLEXCUBE failed: Operation on target FA-DWH-MAIN…

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,570 questions
asked 2026-01-29T08:12:39.6333333+00:00
Xhevahir Mehalla 25 Reputation points
answered 2026-01-29T08:38:27.49+00:00
Pilladi Padma Sai Manisha 3,210 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Azure Synapse Notebook Fails To Find Imports From Jars (Spark 3.5)

So I loaded in the custom jar into the session: %%configure -f { "conf": { "spark.jars":"abfss://******@myplace.dfs.core.windows.net/test/test_2.12-0.1.0-SNAPSHOT.jar" } } After loading I attempt 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,570 questions
asked 2026-01-18T20:30:30.8533333+00:00
Oogway 20 Reputation points Microsoft Employee
accepted 2026-01-27T17:04:17.99+00:00
Oogway 20 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

allocated vcores but not application or user allocated

After running pipelines in Synapse the monitoring shows that the cores are allocated, although the same monitoring is not indicating any detail allocations or applications running or using the cores. Because of this I cannot run notebooks in another…

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,570 questions
asked 2026-01-24T16:18:12.8666667+00:00
Alex Sonea 20 Reputation points
accepted 2026-01-27T14:53:13.2933333+00:00
Alex Sonea 20 Reputation points
2 answers

SQL server slowness

Dear Team, We have been experiencing significant slowness in query execution starting from December 22. Previously, the affected queries (simple SELECT statements on views) would complete within 2–3 minutes, but now they are taking over an hour 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,570 questions
asked 2025-12-30T06:40:24.53+00:00
Khan, Jazeem 0 Reputation points
answered 2026-01-27T09:39:05.43+00:00
Smaran Thoomu 33,110 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

What is the impact of Databricks IP allow/denylists on orchestration using ADF/Synapse

Databricks jobs are often scheduled using Azure Data Factory and/or Synapse. What is the impact of Databricks IP access lists on this orchestration? Can we add service tags to the whitelist to allow ADF? Thanks for elaborating.

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,570 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,822 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,048 questions
asked 2022-07-28T09:17:09.643+00:00
wout 21 Reputation points
accepted 2026-01-24T20:25:58.28+00:00
wout 21 Reputation points
2 answers One of the answers was accepted by the question author.

Configuring Data Source for Azure Synapse Serverless SQL Pool in Azure AI Search

Hi Team, I am trying to add a Synapse serverless SQL pool database as a data source for indexing in Azure AI Search, utilizing managed identity for authentication between services. The following prerequisites have been completed: Azure AI Search's…

Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
1,498 questions
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,570 questions
asked 2024-11-26T14:33:49.4666667+00:00
Suyash Dwivedi 20 Reputation points Microsoft Employee
answered 2026-01-23T07:30:39.6933333+00:00
CLETO FERNANDES 0 Reputation points
1 answer One of the answers was accepted by the question author.

When will Azure Backup Support for HNS be available?

Hi, I was trying to implement Azure vaulted backup using the article https://learn.microsoft.com/en-us/azure/backup/blob-backup-overview?tabs=operational-backup. Unfortunately, I discovered that “HNS-enabled storage accounts are currently not supported.…

Azure Storage
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,765 questions
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,570 questions
asked 2025-01-13T01:32:54.2366667+00:00
Pavel Zemnukhov 20 Reputation points
commented 2026-01-22T16:09:16.1133333+00:00
Ian Carrick (csu) 30 Reputation points