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
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
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 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
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 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
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
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 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
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 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
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
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
[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
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 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
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 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
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
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…