External table in Dedicated pool

Question

I created an external table in the Synapse dedicated pool to a storage account which had public access and it was working fine.

But once the network is enabled only for specific IP as below at the storage account:

I am getting the below error :

So how to handle the above scenario in case of network restrictions on the storage account.

Answer 1

Hi Nandan Hegde,

Thank you for reaching out on Q&A.

From the snippets shared I understand you are facing an error which typically occurs when Synapse SQL pool tries to access external data stored in Azure Data Lake Storage (ADLS) or Blob Storage, but the network restrictions on the storage account prevents the access. You can address this by using SAS tokens, or by simply whitelisting the Synapse's outbound IP's to your Storage Account or you can use a Managed Private Endpoint.

My suggestion is to go for a managed Private endpoint as it ensures secure, scalable and compliant data access in comparison to the others.

I think below Microsoft learn links will be useful, please take a look
How To Create managed private endpoints
Managed Private Endpoints