Jun 21 2021 12:14 PM
Hi I have successfully used the method below to access files from Azure SQL to a Blob container.
CREATE EXTERNAL DATA SOURCE MyAzureBlobStorage
WITH ( TYPE = BLOB_STORAGE,
LOCATION = 'https://sqlchoice.blob.core.windows.net/sqlchoice/samples/load-from-azure-blob-storage',
CREDENTIAL= MyAzureBlobStorageCredential
);
Is it possible to achieve the same thing to a File Share instead of a Blob Container?
CREATE EXTERNAL DATA SOURCE MyAzureFileShare
WITH ( TYPE = BLOB_STORAGE,
LOCATION = 'https://*********.file.core.windows.net/asftest',
CREDENTIAL= MyAzureBlobStorageCredential
)
When I try I get the following error:
Bad or inaccessible location specified in external data source "MyAzureFileShare".
Sep 15 2023 01:39 PM
@Justinrr07 Looks like the question is more than a year old. Did anyone answer this question? I could connect to files stored on blobs, but just not from file shares.