5,373 questions with Azure Synapse Analytics tags

Sort by: Updated
1 answer

Synapse Link with F&O

Hello. We have an Azure Synapse Link with F&O, we want to provide access to one element in the team to he can add tables to Sync in the Synapse Link, but unfortunatelly looks like he only can do this with System Adminsitrator permissions. Do you 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,373 questions
asked 2025-06-26T17:08:34.36+00:00
Manuel Dones 20 Reputation points
commented 2025-06-27T19:21:55.5633333+00:00
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator
0 answers

Issues with Synapse Workflows After Updating Self-hosted Integration Runtime

After updating the Self-hosted Integration Runtime to version 5.54.9267.1 from 5.44.xx on June 10th, the pipeline runs that previously completed in about 30 minutes are now taking several hours and worsening daily. The Integration Runtime operates…

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,373 questions
asked 2025-06-23T13:01:54.3233333+00:00
John Brynford-Jones 1 Reputation point
commented 2025-06-27T17:55:11.7266667+00:00
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Perform Change Data Capture

Hi All, Do you have any pointers on how to perform CDC - change data capture (inserts, updates, deletes) on parquet files in ADLS gen 2 storage. I have another ETL tool called Ab initio but we want synapse to do the heavy lifting.

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,373 questions
asked 2025-06-26T13:49:47.1466667+00:00
Anand Deshpande 0 Reputation points
commented 2025-06-27T12:45:38.1933333+00:00
Anand Deshpande 0 Reputation points
1 answer

Synapse Notebook code to upload data in SharePoint

In most of the code that I am scanning across to upload file into SharePoint via service principal, sites.readwriteAll application permission is being provided to the app. But that is the highest privilege that an app would get across all SharePoints 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,373 questions
asked 2025-06-27T10:10:20.65+00:00
Priya Jha 896 Reputation points
answered 2025-06-27T11:38:01.5766667+00:00
Venkat Reddy Navari 2,885 Reputation points Microsoft External Staff Moderator
1 answer

Cost comparison for Azure synapse Analytics and Microsoft fabric

Hello, i have one requirement. Could you please provide the cost comparison Azure synapse analytics vs Microsoft fabric based on below conditions. **CSV File (Data Lake)**7 locations × 4 files (ABC, DEF, GHI and HIJ) = 28 files/day Each file is…

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,373 questions
asked 2025-06-25T04:58:22.1633333+00:00
Janagam Srikanth 0 Reputation points
commented 2025-06-27T09:10:50.9233333+00:00
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator
0 answers

Missing Database Templates in Synapse

When I try to add a lake database template, the gallery is empty. How can I see the industry templates?

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,373 questions
asked 2025-06-26T15:17:13.81+00:00
Brandon Gross 0 Reputation points
commented 2025-06-27T09:00:55.58+00:00
Venkat Reddy Navari 2,885 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

What type of Synapse architecture should be implemented for organisations that are large and have multiple departments working on the same data?

Hello, I am looking for inputs in relation to the synapse strategy that needs to be adopted. I have the below scenario, Company XYZ has different departments (Dept 1, 2, 3 and 4) that are looking to leverage big data platform like Azure Synapse. The data…

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,373 questions
asked 2025-06-25T14:28:17.1866667+00:00
Parameswaran Serussery Narayanan 15 Reputation points
accepted 2025-06-27T08:54:51.5666667+00:00
Parameswaran Serussery Narayanan 15 Reputation points
1 answer

fixing the synapse analytics deployment issues

{"code":"ValidationFailed","message":"Workspace request validation failed, check error details for more…

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,373 questions
asked 2025-06-25T01:00:36.6833333+00:00
hrishi pal 0 Reputation points
commented 2025-06-27T08:48:25.6966667+00:00
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator
1 answer

Issue using linked service v 2.0 on notebook

Hi, I am accessing the DB in Synapse notebook with linked service version 1. It is working ok but when I changed to version 2, error occurs. Is there any additional setting I need to set in Notebook ? Thank you!

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,373 questions
asked 2025-05-28T03:35:15.4666667+00:00
Lotus88 176 Reputation points
commented 2025-06-27T02:44:09.1566667+00:00
Lotus88 176 Reputation points
1 answer

Issues affecting Synapse with "Can't get enough capacity for optimal performance" error

Hello, We have encountered issues in our test & production environments today. No changes have been made to the environments that we are aware off but pipelines in both environments have failed with an "Can't get enough capacity for optimal…

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,373 questions
asked 2025-06-24T12:55:53.73+00:00
Tori H 0 Reputation points
commented 2025-06-26T10:12:46.0833333+00:00
Venkat Reddy Navari 2,885 Reputation points Microsoft External Staff Moderator
1 answer

Getting Keyboard interrupt error while executing pipeline in Azure Synapse Analytics

Hello, I am using Azure Synapse Analytics to execute a pipeline that loads data from source tables into target tables within an Azure SQL Database. The pipeline follows a parent-child notebook architecture, where the main parent notebook is responsible…

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,373 questions
asked 2025-06-23T12:38:26.08+00:00
Akshay Gopal 5 Reputation points
commented 2025-06-25T13:00:10.33+00:00
J N S S Kasyap 3,625 Reputation points Microsoft External Staff Moderator
1 answer

Azure Synapsis database issue

I am having issue with my dataware house hosted in Azure Synapsis. The data pipelines got failed maxing out the resources, we are having 100 DTUs at that time. We thought that it was a resource constrains and we doubled the DTUs to 200. the pipeline is…

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,373 questions
asked 2025-06-25T07:22:21.4666667+00:00
DXFactor SysOps 0 Reputation points
answered 2025-06-25T09:19:19.3433333+00:00
Venkat Reddy Navari 2,885 Reputation points Microsoft External Staff Moderator
2 answers

Not seeing the option of Linked Services in Azure Synapse Analytics

Hello Azure Support, I'm trying to move data from Azure Synapse Analytics to MongoDB, and I am following the official Microsoft documentation below: 🔗 https://learn.microsoft.com/en-us/azure/data-factory/connector-mongodb?tabs=synapse-analytics As per…

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,373 questions
asked 2025-06-21T15:27:01.1833333+00:00
gomzi 0 Reputation points
edited an answer 2025-06-25T01:11:38.8233333+00:00
Krupal Bandari 770 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Is there an official way to create a Deployment pipeline for Synapse in Azure DevOps without using the classic release pipelines?

Hello, I’m currently working on setting up a CI/CD system for Azure Synapse Analytics. I have a working deployment process, but it’s based on the classic release pipelines in Azure DevOps. While this method is documented in Microsoft’s official guidance…

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,373 questions
asked 2025-06-23T15:11:03.47+00:00
Napsty 45 Reputation points
commented 2025-06-24T18:30:31.2833333+00:00
Napsty 45 Reputation points
1 answer One of the answers was accepted by the question author.

Unable to run query on Synapse Serverless SQL Pool suddenly

I have a few of external table in an Azure Synapse Analytics Serverless SQL Pool which I need to query frequently. I suddenly got this error today. [This query cannot be executed because we can't get enough capacity for optimal performance in time. This…

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,373 questions
asked 2024-06-27T06:30:27.38+00:00
Kenny Wong (HK) 115 Reputation points
commented 2025-06-24T11:49:24.88+00:00
Tori H 0 Reputation points
2 answers 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,373 questions
asked 2023-04-18T05:26:55.7733333+00:00
Gabriel Lafreniere 61 Reputation points
answered 2025-06-24T10:33:30.4766667+00:00
João Tinti 15 Reputation points
1 answer

Unable to create Synapse Workspace

Good evening, when creating a Synapse Workspace, I receive the following error: Reached the maximum number of Synapse workspaces allowed for this subscription. Please contact Microsoft support to request an exception. Subscription:…

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,373 questions
asked 2025-06-19T16:17:45.0433333+00:00
Panagiotis Sykas 0 Reputation points
commented 2025-06-23T19:13:17.07+00:00
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator
2 answers

Oracle Linked Service 2.0 Failing with Bad Username and Password

We currently have the Oracle v1 Linked Service configured and running with an Oracle 9iR2 database. It works with no issues. However with v2 it will not connect no matter what combination or Encryption client and/or Crypto Checksum Client we use. We've…

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,373 questions
asked 2025-06-18T21:50:40.69+00:00
17468030 0 Reputation points
commented 2025-06-23T16:28:36.19+00:00
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator
1 answer

How do I fix a synapse link that was updating partition tables but stopped on June 4th.

We're doing a proof of concept for a Dataverse to Synapse data link which was working fine until about June 4th. For some reason, since then, the partition folders of the tables have stopped updating. The "live" folder for tables is continuing…

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,373 questions
asked 2025-06-12T14:12:23.38+00:00
Al Villeneuve 0 Reputation points
commented 2025-06-23T13:40:49.23+00:00
Al Villeneuve 0 Reputation points
0 answers

How to resolve an error with too many vcores being requested?

I'm trying to run a simple script on a spark notebook. But I keep running into this error. Your Spark job requested 672 vcores. However, the workspace has a 12 core limit. The script in itself should not require that many vcores as it is only checking…

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,373 questions
asked 2025-06-09T16:58:20.6533333+00:00
Joseph Y. Lee 5 Reputation points
edited a comment 2025-06-23T06:40:00.13+00:00
Pritam Kabiraj 315 Reputation points Microsoft External Staff Moderator