search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
9.77k stars 8.79k forks source link

Sql sample files in blob storage unavailable #1172

Open OzBob opened 1 year ago

OzBob commented 1 year ago

Sample files for trialling Bulk Import (and other samples) are denied due to Container security being set as "PublicAccessNotPermitted"

https://github.com/microsoft/sql-server-samples/blob/master/samples/features/sql-bulk-load/load-from-azure-blob-storage/README.md lists several sample files, e.g. https://sqlchoice.blob.core.windows.net/sqlchoice/samples/load-from-azure-blob-storage/product.bcp

but clicking the link returns

<Error>
<Code>PublicAccessNotPermitted</Code>
<Message>Public access is not permitted on this storage account. RequestId:0b4776f3-301e-00e8-046e-a2cc98000000 Time:2023-06-19T05:23:32.7363081Z</Message>
</Error>