1 year ago

#380222

test-img

Susen Maharjan

What is the correct way to set LOCATION of local Azure emulator storage?

Setting the location of Azure blob URL has no problem. For example:

CREATE EXTERNAL DATA SOURCE YourDataSource WITH
(
     TYPE = BLOB_STORAGE,
     LOCATION = 'https://yourazurestorage.blob.core.windows.net',
     CREDENTIAL = [YourSasCredential]
)

CREATE EXTERNAL DATA SOURCE FormatFilesDataSource WITH
(
     TYPE = BLOB_STORAGE,
     LOCATION = 'https://yourazurestorage.blob.core.windows.net',
     CREDENTIAL = [FormatFilesCredential]
)

But if we set LOCATION of local Azure emulator, I keep on getting

Bad or inaccessible location specified in external data source

For example:

CREATE EXTERNAL DATA SOURCE YourDataSource WITH
(
    TYPE = BLOB_STORAGE,
    LOCATION = 'http://127.0.0.1:10000/devstoreaccount1',
    CREDENTIAL = [YourSasCredential]
)

CREATE EXTERNAL DATA SOURCE FormatFilesDataSource WITH
(
      TYPE = BLOB_STORAGE,
      LOCATION = 'http://127.0.0.1:10000/devstoreaccount1',
      CREDENTIAL = [FormatFilesCredential]
)

Query in order to test this is

SELECT *
FROM OPENROWSET(
    BULK 'folder/file.csv',
    DATA_SOURCE = 'YourDataSource',
    FIRSTROW=2,
    FORMATFILE='format-files/format.fmt',
    FORMATFILE_DATA_SOURCE='FormatFilesDataSource'
) AS DataFile

sql-server

azure

tsql

azure-blob-storage

azure-storage

0 Answers

Your Answer

Accepted video resources