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: