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

sakuraime 2,286 Reputation points

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 Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,688 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.
3,115 questions
0 comments No comments
{count} votes

Accepted answer
  1. Samara Soucy - MSFT 5,021 Reputation points

    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.


0 additional answers

Sort by: Most helpful