I have created a stored procedure inside ForEach pipeline in Azure synapse Analytics. When I run the pipeline, it gives me error:

{
“errorCode”: “2011”,
“message”: “Content of directory on path ‘https://adventurerasseldata.dfs.core.windows.net/adventure-gold/SalesLT/Address/ProductDescription/_delta_log/.‘ cannot be listed.”,
“failureType”: “UserError”,
“target”: “Stored procedure to get table name”,
“details”: []
}

According to microsoft, the solution is to grant yourself the Storage Blob Data Contributor role in the storage account you’re trying to query. I did that but I still get the error.

enter image description here