5,557 questions with Azure Synapse Analytics tags

Sort by: Updated
2 answers

Transitioning Synapse workspace private Link

We currently have an Azure Synapse Analytics workspace that is publicly accessible and are planning to transition it to use Private Endpoints (Private Link) for improved network security. I would like clarification on the correct and recommended steps 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,557 questions
asked 2026-01-19T06:36:20.6166667+00:00
prabu heins 5 Reputation points
commented 2026-01-20T13:40:35.0966667+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
2 answers

Connectivity between sqlmi and synapse

Can't access the tables of our Azure Synapse database - Description: We are unable to access the tables of our Azure Synapse database, while connecting through MSQL server: Azure SQL Database Managed Instance: kite.4b3fa7b60a28.database.windows.net…

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,557 questions
asked 2026-01-16T02:50:06.16+00:00
RajeshKumar G 0 Reputation points
commented 2026-01-20T11:46:02.7+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
2 answers

Unable to connect synapse analytics endpoint to power BI - Permission Issues

Hi , I have recently create a synapse link for dataverse to export my data from D365 FO to synapse (I have created apache spark pool for parquet files) . It was successfull and I can connect to power BI since I have owner and admin access to datalake ,…

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,557 questions
asked 2026-01-19T10:43:17.02+00:00
Athira Reghuraman 95 Reputation points
answered 2026-01-20T11:20:57.87+00:00
Smaran Thoomu 32,780 Reputation points Microsoft External Staff Moderator
0 answers

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,557 questions
asked 2026-01-18T20:30:30.8533333+00:00
Oogway 0 Reputation points Microsoft Employee
commented 2026-01-20T04:44:31.26+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
0 answers

I want to set up python environment along with R on azure synapse cluster

I want to set up python environment along with R packages in yml on azure synapse cluster using workspace packages option in "Apache Spark pools can be customized with additional libraries by assigning workspace packages or by providing a library…

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,557 questions
asked 2026-01-16T18:56:43.8033333+00:00
Kumar Ravi (HCL TECHNOLOGIES CORPORATE SER) 0 Reputation points Microsoft External Staff
commented 2026-01-19T10:42:00.0566667+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
2 answers

Azure Synapse Analytics Workspace Quota Increase Request has invalid conditions on request quota field

We want to provision a production environment Workspace after creating equivalent dev and staging instances. Due to max limit of 2 workspaces in pay as you go subscription, When I try to create quota increase request, the Quota details window incorrectly…

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,557 questions
asked 2026-01-15T21:11:13.65+00:00
Omair Qazi 0 Reputation points
answered 2026-01-16T10:20:02.2733333+00:00
Omair Qazi 0 Reputation points
0 answers

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,557 questions
asked 2026-01-15T22:17:21.21+00:00
Long Wen 1 Reputation point Microsoft Employee
commented 2026-01-15T22:56:23.3333333+00:00
VRISHABHANATH PATIL 4,200 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

ADF unable to ingest partitioned FnO data from Azure Synapse Link for Dataverse into Azure SQL

Hi, I am working with Dynamics 365 Finance & Operations data replicated via Azure Synapse Link for Dataverse into Azure Data Lake Storage Gen2. The Synapse Link setup is working as expected: FnO tables are created in ADLS Gen2 Data is stored 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,557 questions
asked 2026-01-09T08:34:36.2233333+00:00
Raheel Islam 41 Reputation points
commented 2026-01-14T15:17:38.3766667+00:00
Raheel Islam 41 Reputation points
2 answers

Azure Synapse RLS based in Logged in users AZ AD security group he belongs to

Hi, In Azure synapse dedicated SQl pool I am trying to implement and test row level security using security predicate function and security policy based on logged in users Azure Active directory security group. Created external Az AD security group as…

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,557 questions
asked 2026-01-13T15:27:42.8766667+00:00
Sri Challa 0 Reputation points
answered 2026-01-14T06:51:20.52+00:00
Smaran Thoomu 32,780 Reputation points Microsoft External Staff Moderator
2 answers

Is it possible to get Spark Event Log from History Server via API

Is it possible to get Spark Event Log from the History server via API similarly to the executor…

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,557 questions
asked 2026-01-08T14:45:18.4266667+00:00
Miika Niemi 0 Reputation points
answered 2026-01-12T04:58:11.1833333+00:00
Smaran Thoomu 32,780 Reputation points Microsoft External Staff Moderator
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,557 questions
asked 2023-04-18T05:26:55.7733333+00:00
Gabriel Lafreniere 61 Reputation points
commented 2026-01-11T01:49:32.6+00:00
Mareddy, Suri 0 Reputation points
2 answers

Synapse Event-Based Trigger Fires Twice on Single File Upload / Overwrite in ADLS Gen2

Hello, We have configured an event-based trigger in Azure Synapse Analytics to start a pipeline when a file is uploaded to ADLS Gen2. However, when a file is uploaded or overwritten only once, the trigger fires twice within a few seconds, resulting 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,557 questions
asked 2025-12-26T14:14:01.5733333+00:00
Indrajith Mourya GMB [C] 0 Reputation points
edited a comment 2026-01-09T12:19:00.4833333+00:00
Indrajith Mourya GMB [C] 0 Reputation points
2 answers One of the answers was accepted by the question author.

How to connect from Azure Synapse Workspace to MSSQL server installed on Azure VM

Dear Team, I want to connect from Azure Synapse Analytics workspace to my MSSQL server installed on Azure VM (IaaS) to select data with Spark scripts and push it into ADLS. I have created Azure Synapse Analytics workspace in manager VNET and my Azure VM…

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,557 questions
asked 2026-01-05T06:58:11.63+00:00
Kishor Gavali 60 Reputation points
commented 2026-01-09T11:07:03.52+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator
2 answers

[Bug] Changing language don't work on Synapse Analytics web

Hello: I've tried to change the language for Synapse Analytics from Spanish to English, but after applying the change, the URL gets trimmed and therefore it won't load Steps: Enter to a localized path for Synapse Analytics (example:…

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,557 questions
asked 2026-01-06T16:13:16.5333333+00:00
Juan C. / PotterSys 0 Reputation points
commented 2026-01-08T14:35:13.5866667+00:00
VRISHABHANATH PATIL 4,200 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Share a self-hosted integration runtime with Azure Synapse

Hi, I want to use the same Integration Runtime in Azure Synapse as I am currently using in existing Data Factory pipelines. I managed to grant permission to Synapse by using the "Enter Manually" option and pasting the Managed Identty Object…

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,557 questions
asked 2020-07-20T11:15:58.977+00:00
commented 2026-01-07T12:33:50.0466667+00:00
Sacher, Wolf-Rüdiger 21 Reputation points
2 answers

Azure Synapse Copy Activity REST sink HTTP compression is corrupting the payload

I believe there is a bug in azure synapse that is causing the payload to be corrupted on a REST sink with http compression turned on. When http compression is set to GZIP the payload is either empty or corrupt, it's hard to say. Is this a known 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,557 questions
asked 2025-11-05T23:42:56.99+00:00
Seth Coleman 51 Reputation points
answered 2026-01-05T09:51:16.86+00:00
Smaran Thoomu 32,780 Reputation points Microsoft External Staff Moderator
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,557 questions
asked 2026-01-02T20:44:29.58+00:00
Christine Han 20 Reputation points Microsoft Employee
accepted 2026-01-05T04:52:31.5266667+00:00
Christine Han 20 Reputation points Microsoft Employee
1 answer

Azure Synapse copy activity error "There are no batches in the input script"

I'm using a copy activity where the data source is an external table, which I'm trying to get the data through the "query" option. I've already queried this external table with a SQL script using the exactly same query I'm using in the activity…

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,557 questions
asked 2025-12-29T14:56:37.56+00:00
Pedro 0 Reputation points
commented 2026-01-02T14:49:10.51+00:00
Manoj Kumar Boyini 4,000 Reputation points Microsoft External Staff Moderator
1 answer

Why does this page pop up when running the SQL script?

After clicking "Cancel", when you try to query again, the same page still appears.

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,557 questions
asked 2025-12-19T07:27:40.7033333+00:00
Wang, Shuo 0 Reputation points
commented 2025-12-31T08:15:16.0133333+00:00
Kalyani Kondavaradala 4,680 Reputation points Microsoft External Staff Moderator
1 answer

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,557 questions
asked 2025-12-30T06:40:24.53+00:00
Khan, Jazeem 0 Reputation points
commented 2025-12-30T22:39:51.1566667+00:00
Pilladi Padma Sai Manisha 2,135 Reputation points Microsoft External Staff Moderator