5,541 questions with Azure Synapse Analytics tags

Sort by: Updated
2 answers

Azure synapse analytics running manual notebook is taking less time and when running with pipeline it's taking more time.

Why does my Azure Synapse notebook run much faster manually, but becomes slow and inconsistent when executed through a Synapse pipeline (especially with parallel notebook execution)? I am using Azure Synapse Analytics with a dedicated Spark pool. When I…

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,541 questions
asked 2025-12-10T07:47:38.4+00:00
ADITYA SINGH 0 Reputation points
edited a comment 2025-12-23T05:44:02.2366667+00:00
VRISHABHANATH PATIL 3,060 Reputation points Microsoft External Staff Moderator
2 answers

Timestamp difference between what's seen in D365 and what I retrieve in Databricks

Hello ! Sorry for the tags I didn't find the appropriate one My company has D365 F&O. We use Azure Synapse Link to put D365 data into parquet files in a storage account so we can use it in Databricks. Nothing weird I am on France time zone. I know…

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,541 questions
asked 2025-12-11T08:08:46.03+00:00
Alexis Blas 0 Reputation points
commented 2025-12-22T20:06:26.18+00:00
Pilladi Padma Sai Manisha 995 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Cannot use managed identity to connect to service bus

I am trying to connect to Service Bus from Azure synapse using managed identity but it is not letting me to. I need this so that I can disable local auth in Service Bus. Is it possible to connect to service bus from Synapse with local auth disabled 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,541 questions
asked 2025-12-19T22:46:37.8133333+00:00
Prajwal Pyakurel 0 Reputation points Microsoft Employee
accepted 2025-12-22T19:14:45.3333333+00:00
Prajwal Pyakurel 0 Reputation points Microsoft Employee
1 answer

Synapse Dedicated pool Scalling up issue

Hi There, We scaled our Synapse Dedicated pool from 300 DWU's to 400 DWU's this morning and its been 6 hours since the request and nothing is happening...

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,541 questions
asked 2025-12-05T10:02:19.0933333+00:00
Samir Kohli 0 Reputation points
commented 2025-12-22T10:08:26.3366667+00:00
VRISHABHANATH PATIL 3,060 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,541 questions
asked 2025-12-19T07:27:40.7033333+00:00
Wang, Shuo 0 Reputation points
answered 2025-12-19T14:29:18.4566667+00:00
Kalyani Kondavaradala 4,600 Reputation points Microsoft External Staff Moderator
1 answer

Can I use the same VM for On-prem-gateway and Self-hosted IR for Synapse?

Hello , I have a solution which extracts data from oracle db on OCI and store in data lake. Then use Synapse pipilines and Data flows to process the data and store them in sql db. I use self-hosted IR to extract data from Oracle. I have another solution…

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,541 questions
asked 2025-12-16T13:07:21.9066667+00:00
Xhevahir Mehalla 25 Reputation points
commented 2025-12-18T09:27:47.3066667+00:00
Kalyani Kondavaradala 4,600 Reputation points Microsoft External Staff Moderator
3 answers

Can't create Azure Synapse link to Dataverse in Power Platform despite having correct apache spark version

I have a dynamics environment in Canada region I have an Azure Synapse Workspace containing a Spark Pool in the Canada East region (there was no 'Canada' option) In Powerapps, I try to create a link to the Dataverse, and after choosing the Azure Synapse…

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,541 questions
asked 2025-10-21T17:50:16.3766667+00:00
Rick Fleischmann 0 Reputation points
commented 2025-12-18T01:33:43.5033333+00:00
Ojha, Arundhati 0 Reputation points
2 answers

Synapse notebooks in a workspace don't load BUT are being run by triggers

I have a workspace with all of our colleagues. Platform did a change and it seems that triggers and notebooks are all gone. We cannot access them at all (this has huge business implications for us). We can see the blob storage and the spark pools. 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,541 questions
asked 2025-12-13T14:35:01.5633333+00:00
Carlos VI 0 Reputation points
commented 2025-12-17T09:01:37.3333333+00:00
VRISHABHANATH PATIL 3,060 Reputation points Microsoft External Staff Moderator
2 answers

How to add extended properties (description) to Tables and Columns in Azure Dedicated SQL Pool?

Is there any possible way to add description to Tables or columns in Azure Dedicated SQL Pool. I tried with sp_addextendedproperty, but I got the error: "PROCEDURE 'sp_addextendedproperty' is not supported."

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,541 questions
asked 2025-12-03T14:51:10.2966667+00:00
Priya S 0 Reputation points
commented 2025-12-17T07:32:50.3266667+00:00
VRISHABHANATH PATIL 3,060 Reputation points Microsoft External Staff Moderator
1 answer

Automating Table Activation and Deployment for Synapse Link in Dynamics 365 Dataverse

I am using Synapse Link for Dataverse to bring data from Dynamics 365, where I need to manually activate each table to load data into Azure Data Lake Storage (ADLS) Gen2. I seek a solution to automate this activation process and to deploy the same…

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,541 questions
asked 2024-08-02T15:17:52.7333333+00:00
Sriram M 40 Reputation points
edited a comment 2025-12-16T23:03:44.6833333+00:00
Dan P 0 Reputation points
2 answers

how to find azure synapse Vnet/subnet

I am able to find the synapse vnet info by checking synapse IP, but wonder if there is a way to find Vnet info directly by Synapse workspace name? Thanks in advance.

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,541 questions
asked 2025-12-09T15:13:21.0066667+00:00
Wenzhe Zhang 0 Reputation points
commented 2025-12-12T06:36:42.8833333+00:00
VRISHABHANATH PATIL 3,060 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How to fix Cannot read properties of undefined (reading 'valid') error while attempting scaling a Synapse SQL Dedicated pool

Receiving an error message when attempting to scale the Synapse Analytics dedicated pool: Any ideas on how to resolve this? { "shellProps": { "sessionId": "e72684e96bd24d33a7a77f87c774c1cd", "extName":…

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,541 questions
asked 2025-12-08T09:34:43.43+00:00
Vardges Bokhyan 20 Reputation points
edited an answer 2025-12-09T10:47:46.8033333+00:00
Manoj Kumar Boyini 2,120 Reputation points Microsoft External Staff Moderator
2 answers

I’m experiencing issues loading Netsuite transaction table data into ADLS Gen2 via an ODBC connection in Azure Synapse. What are the recommended troubleshooting steps or configuration changes to fix this?

{ "errorCode": "2200", "message": "Failure happened on 'Source' side. 'Type=System.InvalidOperationException,Message=The connection has been…

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,541 questions
asked 2025-11-27T15:23:44.1333333+00:00
Suraj Surendran 60 Reputation points
commented 2025-12-08T16:08:51.5266667+00:00
Manoj Kumar Boyini 2,120 Reputation points Microsoft External Staff Moderator
6 answers One of the answers was accepted by the question author.

Which is the best option for data warehouse / Power BI solution?

Hello, I am building a data warehouse in Azure from several external data sources. Data can be imported via pipelines in Data Factory (or Azure Synapse). Data is to be stored in Azure. Reporting through Power BI is required. There seem to be a…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
495 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,541 questions
asked 2021-10-19T10:02:24.153+00:00
System2000 236 Reputation points
commented 2025-12-08T13:36:56.4533333+00:00
Shambhavi Sinai Adwalpalkar 0 Reputation points
2 answers

Trouble connecting from synapse notebook to eventhub using managed identity

I am trying to write to eventhub from synapse notebook using managed identity but hitting an error. I have enabled the session to use and have managed identity as well. Code Error: com.azure.identity.CredentialUnavailableException: Managed Identity…

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,541 questions
asked 2025-11-23T16:34:05.1+00:00
Tharangini Anandan 0 Reputation points Microsoft Employee
commented 2025-12-04T04:12:04.04+00:00
Pratyush Vashistha 5,130 Reputation points Microsoft External Staff Moderator
2 answers

Issues with Synapse Workflows After Auto-Update of Self-Hosted Integration Runtime to 5.55.9315.1 (Salesforce V2 Empty-Result Parquet Schema Regression)

Description After our Self-Hosted Integration Runtime (SHIR) auto-updated to v5.55.9315.1 on November 15, 2025, Synapse pipelines that use the Salesforce V2 connector began producing Parquet files with an incomplete schema when an incremental load…

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,541 questions
asked 2025-11-17T20:19:47.57+00:00
Jeff S 5 Reputation points
commented 2025-12-03T19:36:29.3666667+00:00
Swapnesh Panchal 1,540 Reputation points Microsoft External Staff Moderator
2 answers

How can I connect a Fabric Trial to Dataverse?

I am trying to connect Dataverse to Azure Synapse Analytics in a Fabric Trial. The Power Apps wizard asks for Subscription ID and Resource Group. The problem is that the Fabric trial does not appear in my list of Azure Subscriptions. (I have the Global…

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,541 questions
asked 2025-11-11T12:17:06.86+00:00
Charles Leighton 0 Reputation points
recommended 2025-12-03T10:30:23.0233333+00:00
Alexandra Tanasescu 0 Reputation points Moderator
1 answer

Terraform setup to collect container logs in analytics workspace

Hello, I've got a small PoC setup involving: An AKS cluster A Log Analytics workspace A data collection rule linking the AKS cluster to the log analytics workspace When I deploy a demo namespace (the contoso pet shop) the application works, but none…

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,541 questions
asked 2025-11-27T14:26:43.04+00:00
Erik Heeren 60 Reputation points
commented 2025-12-03T02:45:35.89+00:00
Bharath Y P 2,825 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Please help me restore a deleted deployment

I mistakenly deleted some deployments that were in a failed state, not knowing that these failed deployments basically deleted everything in my dev environment. I have lost all our data extraction pipelines, linked services, almost everything. From what…

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,541 questions
asked 2025-11-26T16:02:09.8933333+00:00
Roshan Govind 25 Reputation points
accepted 2025-12-02T09:18:01.5366667+00:00
Roshan Govind 25 Reputation points
4 answers

Does ANALYZE TABLE work with Spark 3.5 and are statistics exposed to AQE?

I am running a notebook in a Spark 3.5 cluster in which I am basically using MERGE to incrementally add to my delta tables. While I was monitoring my spark log execution, I noticed messages like this: 2025-11-24 08:36:36,924 INFO…

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,541 questions
asked 2025-11-24T11:28:28.5+00:00
fred31330 81 Reputation points
answered 2025-11-27T16:47:46.4133333+00:00
fred31330 81 Reputation points