Azure synapse serverless query blob storage

sakuraime 2,351 Reputation points
2021-03-12T11:03:39.047+00:00

I have the following error while using serverless Azure synapse .
77186-image.png

May I know is it still not supporting ADLS Gen 2 which has Hierarchical namespace enabled ? I have another blob storage and using same method and can browse the data .

Access blob storage data through the serverless pool, is actually using what kind of user or access right ?

Can I create another Serverless SQL POOL ?

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.
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,971 Reputation points Volunteer Moderator
    2021-03-12T12:14:12.607+00:00

    It works for me. I have granted access to synapse workspace as Storage blob data contributor for the ADLSG2 account

    77127-image.png

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav


Your answer

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