Blog Post

Azure Synapse Analytics Blog
8 MIN READ

Writing data using Azure Synapse Dedicated SQL Pool Connector for Apache Spark

scirqueira's avatar
scirqueira
Icon for Microsoft rankMicrosoft
Oct 19, 2022
Summary  A common data engineering task is explore, transform, and load data into data warehouse using Azure Synapse Apache Spark. The Azure Synapse Dedicated SQL Pool Connector for Apache Spark is...
Updated Mar 08, 2023
Version 2.0
synapse spark
synapse studio
synapse support
scirqueira's avatar
scirqueira
Icon for Microsoft rankMicrosoft
Feb 16, 2024

Hi Mukul_Oberoi, 

 

You need to grant all the permissions for both, the user who is running adhoc notebook and also for managed identity if running with pipelines. 

 

1 -  SQL Request for manual run (user based):

2 -  SQL Request for pipeline execution (managed identity based):