question

SteinmannDaniel-0071 avatar image
0 Votes"
SteinmannDaniel-0071 asked SteinmannDaniel-0071 commented

Synapse: Create and query external tables from a file in Azure Data Lake, Networking

I am trying to follow the steps in the official documentation here to automatically generate an external table from a Parquet file. All required RBAC roles are set, and the script generation works if the storage account is configured to allow connections from all networks. Now when I restrict network access, and add the Synapse workspace under "Resource Instances" in the storage account networking options, script generation does not work anymore. The error is reproducible, so if I allow access from all networks again, script generation works again.

Thanks for your help!

Error screen when networking is restricted:
203742-synapse-external-table-error.jpg


azure-synapse-analytics
· 2
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.

Hi @SteinmannDaniel-0071 ,
Appreciate if you could update the valid link for the document to investigate further on the issue. Thanks in advance!

1 Vote 1 ·

Sorry, it's updated.

1 Vote 1 ·

0 Answers