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
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
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
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
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
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
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
fixing the synapse analytics deployment issues
{"code":"ValidationFailed","message":"Workspace request validation failed, check error details for more…
Azure Synapse Analytics
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
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
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 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
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
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
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 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
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
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
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
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…