question

sakuraime avatar image
0 Votes"
sakuraime asked KranthiPakala-MSFT commented

Azure synapse serverless query blob storage

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
image.png (27.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered KranthiPakala-MSFT commented

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


image.png (25.6 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

what's the synapse workspace ID ?

0 Votes 0 ·

in your case, is it enable or disable ?
77604-image.png


0 Votes 0 ·
image.png (3.7 KiB)

Enabled.. it is ADLS Gen2 as I mentioned

0 Votes 0 ·

Hi @sakuraime,

Following up to see if the above info from @VaibhavChaudhari was helpful to resolve your issue? If that answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread.

Do let us know if you still need assistance ?

Thanks

0 Votes 0 ·

We still have not heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Thank you

0 Votes 0 ·