Hello
I want to insert into Azure all at once, but I get the following error.
ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'AzureBulkInsert123';
GO
ALTER DATABASE SCOPED CREDENTIAL MyAzureBlobStorageCredential
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = 'se=2021-04-30T10:25:16Z&sip=192.168.0.226&spr=https&sv=2020-02-10&sr=b&sig=nvF6dpC02N%2FoLQBROvnKrhWieEyz388***';
DROP EXTERNAL DATA SOURCE MyAzureBlobStorage;
CREATE EXTERNAL DATA SOURCE MyAzureBlobStorage
WITH ( TYPE = BLOB_STORAGE,
LOCATION = 'https://dataarea.blob.core.windows.net/bulk-ins-data'
, CREDENTIAL= MyAzureBlobStorageCredential --> CREDENTIAL is not required if a blob is configured for public (anonymous) access!
);
BULK INSERT dbo.{TABLE}
FROM 'test-00001.csv'
WITH(
DATA_SOURCE = 'MyAzureBlobStorage',
DATAFILETYPE = 'char',
FORMAT = 'CSV'
);
Cannot bulk load because the file "test-00001.csv" could not be opened. Operating system error code 5(Access is denied.).
Please tell me.