Notebook : AccessDeniedException

Question

Hello,

I am trying to save a delta/parquet file into the ADLS Gen2 using a PySpark Notebook as follows :

delta_output_path = "abfss://container@account.dfs.core.windows.net/clients/"

df_result.write.format("delta").mode("overwrite").save(delta_output_path)

Eventhough, I granted Azure Blob Data contributor role to the Synapse Workspace and ADF, I am still getting this error : AccessDeniedException: Operation failed: "This request is not authorized to perform this operation using this permission.", 403, HEAD

Answer

Hi @Wajih Arfaoui
Welcome to Microsoft Q&A platform and thanks for posting your query here.

From the permission you have doesn't have Storage Blob Data Contributor: Use to grant read/write/delete permissions to Blob storage resources. To resolve this issue, you need to verify the access permissions for the ADF/synapse and user type:

Note: Storage Blob Data Contributor: Use to grant read/write/delete permissions to Blob storage resources.

Synapse permissions: Kindly check the permissions on the Storage account as shown below:

Synapse-ADLSGen2-Access

User permissions: Check the user permission on the storage account as shown below:

Synapse-ADLSGen2-UserAccess

After granting the permissions - make sure to wait for 10-15 mins to propagate the permissions and then re-try to run the notebook.

In case, if you are experiencing any issue, please do let us know.

For more details, refer to Notebook - This request is not authorized to perform this operation. , 403.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Notebook : AccessDeniedException

1 answer

Your answer