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

Question

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 ?

Answer 1

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.