See modified date/times of Notebooks?
Is there a way, in Azure Synapse Analytics, to see modified date/times of NOTEBOOKS? Or of SQL Scripts -- the "Develop" section objects in general? (Or, is that only available on whatever changes have been checked into GIT / other…
Azure Synapse Analytics
Azure Synapse partiioning best practices
Hi, I'm trying to develop a ADLS folder structure to provide analytics via Synapse Spark. The table I want to expose via Spark is: (State, City, Gender, Sum of Population, Sum of deaths, Sum of Births) On ADLS, the folder structure…
Azure Synapse Analytics
Do i need to take the DP-203 exam as it will be retired in march 2025 ?
I'm preparing for DP-203 exam . Since its being retired in march 2025 ,Please advise if I should stop the DP-203 preparation and start preparing for DP-700 ? . Does passing DP-203 a Prerequisite for understanding the contents of DP-700 ?
Azure Synapse Analytics
Getting Error while pulling data from fabric lakehouse table: Error code 21446 Details Invalid table! Parquet column is not defined in delta metadata. Column name: _change_type.
Error details Error code 21446 Details Invalid table! Parquet column is not defined in delta metadata. Column name: _change_type. Activity ID: dfc77409-e06f-4ab8-82e1-502ac46f4344 I am trying to preview data for some tables and it is giving me this…
Azure Synapse Analytics
Does synapse serverless sql pool OPENROWSET support "parquest based structured stream" format?
I can read from a data lake structured stream using synapse serverless sql pool OPENROWSET, by specifying FORMAT = 'SSTREAM'. Does OPENROWSET support "parquest based structured stream" format? If yes, then what value should I specify to FORMAT…
Azure Data Lake Storage
Azure Synapse Analytics
Error on creating Synapse Spark database
Hi every one, I'm trying to create a database in Synapse Spark Notebook, but I'm getting this error: The very same error appears without the keyword LOCATION Regards Jona
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
Create DB identity in synapse notebook
Hi, I want to create a Synapse notebook where can read data from Azure SQL server DB. So I need to connect the DB via jdbc and enter the user name and password like code below. Is there a way where I can store this username and password somewhere so that…
Azure Synapse Analytics
Unable to switch to data flow debug mode on azure synapse. Failed to setup debug session
I'm currently unable to switch to debug mode in azure synapse workspace and the pipeline runs takes forever to complete if started manually.
Azure Synapse Analytics
How to enable System Assigned in Azure Synapse?
Hi, Does anyone how to turn on the "system assigned" from Azure Synapse identity? I seems cannot see this option on my Synapse workspace. Is there anything I need to enable in the workspace to see this option? Thanks in advance.
Azure Synapse Analytics
How to Override Linked Service Parameters (e.g., Databricks domain) in Azure Synapse CI/CD YAML Pipeline?
Hello, I’m currently working on a CI/CD pipeline for Azure Synapse, integrated with Azure DevOps as the source repository. I’ve successfully built and tested the entire deployment pipeline between the Development and QA Synapse workspaces. Everything…
Azure Synapse Analytics
I want to know whether incremental load is possible in case where the source data set is Azure SQL database and sink is REST API.
Hi Team, Does ADF/Azure Synapse pipline support incremental load from Azure SQL Database to REST API ? If yes, Would be very helpful if you could please provide the documentation/ solution. Regards,
Azure Synapse Analytics
Cannot access secrets from notebook call by pipeline
Hi, I have grant secrets permission to my Synapse workspace and my microsoft entra ID. I have notebooks that read the secrets created by me. I can run the notebook to access my secrets and it is working. However when I tried to run the notebook from…
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
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
Issue with "Too Many Requests" Error in App Provisioning
I ran the code in the test file within Synapse and observed a "Too Many Requests" error while processing records for App provisioning. We also confirmed this issue via Postman, where the same error was encountered. Can anyone help me to…
Azure Synapse Analytics
Azure Data Factory
Azure App Service

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
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
Need clarity on Synapse and Data Factory and Databricks
Please spare few mins on my question clearly . I am struggling to convince the customer/interviewer when they need clarification on what service to be used for ingestion , transformation , orchestration , data modelling . I answer this way " We…
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…