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

Daniel Steinmann 6 Reputation points
2022-05-19T13:24:29.41+00:00

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
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.
5,373 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.