Share via

ADLS Storage access forbidden 403 in synapse

Nick Wong 170 Reputation points
2024-07-18T12:47:04.3666667+00:00

Hello, I tried to run the sql code under synpase platform but seems like i dont have access to it, but i could access them when running activity like 'copy data etc.

What should i do next to open the access?

User's image

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,480 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,987 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amrinder Singh 5,155 Reputation points Microsoft Employee
    2024-07-18T17:52:00.45+00:00

    Hi Nick Wong - Thanks for reaching out.

    Can you share the exception or any failed request ID in the exception?

    What's the auth you are using in order to access the storage? Is it Account Key, SAS, AD role? if working with roles, you need to ensure that you have appropriate roles such as Reader (Management Plane) & Storage Blob Data Contributor (Data Plane)

    Do you have any network level restriction on the storage account? If yes, that could also be one of the issue. In that case, can you try flipping to All Networks and then try to access the same to see if that works?

    Looking forward to hear from your end.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.