question

sakuraime avatar image
0 Votes"
sakuraime asked sakuraime commented

Azure synapse sql dedicated pool , on-demand and spark pool access to blob storage

If I have a dedicated pool, on-demand sql pool and spark pool in synapse studio and would like to access to blob storage account which is blocked all network and only allow private endpoint access.. is it possible ??

coz I found the spark pool in order to access the blob storage account, the blob storage account need to allow all network .

how to do it without allowing all network from blob storage ?

azure-synapse-analyticsazure-blob-storage
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

SamaraSoucy-MSFT avatar image
0 Votes"
SamaraSoucy-MSFT answered sakuraime commented

There is a feature in public preview for Azure services that don't have the ability to run inside a traditional Azure VNET. Currently this is only available for Synapse, but will be expanded to other services. You can add access for your Synapse workspace on the network tab of your storage account. You will still need to assign the Synapse managed identity to the 'Storage Blob Data Contributor' role on the storage account to allow it to access data.

82600-2021-03-29-23-38-34-sasoucystoragevnet-microsoft-a.png



· 1
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.


for spark pool network access to storage account will need to create a manged private endpoint to the blob storage
otherwise it will through internet


0 Votes 0 ·