How to replace Azure SQL DB blob storage credentials

Log in to the target DB through tools such as Azure Data Studio, and execute the following SQL to delete the current credentials.

DROP EXTERNAL DATA SOURCE BlobStorageDataSource;

DROP DATABASE SCOPED CREDENTIAL BlobAccessCredential;

Execute the following SQL to create a new credentials (replace Placeholder with the value of the real environment).

• PLACEHOLDER_BLOB_SHARED_ACCESS_SIGNATURE: storage SAS token
• PLACEHOLDER_BLOB_NAME: storage name

CREATE DATABASE SCOPED CREDENTIAL BlobAccessCredential
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = 'PLACEHOLDER_BLOB_SHARED_ACCESS_SIGNATURE';
 
CREATE EXTERNAL DATA SOURCE BlobStorageDataSource
WITH (TYPE = BLOB_STORAGE,
    LOCATION = 'https://PLACEHOLDER_BLOB_NAME.blob.core.windows.net',
    CREDENTIAL= BlobAccessCredential);