Azure SQL bulk insert from blob storage failure: Referenced external data source "AzureBlobStorage" not found

Tin, Nilar Win 1 Reputation point
2021-10-05T08:44:10.123+00:00

Hello,

I am new in Azure, please bear with me.

I found several same thread and answers and I followed the instructions but I couldn't solve and error.
Although I am following the below example, does not work for me.

https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/sql-bulk-load/load-from-azure-blob-storage

To solve that error I did the below setting

Add role assignment in Access Control (IAM)
Blob storage and container set to public
Set SAS token while bulk import

I am assuming I am missing some security setting or authority setting but I can't figure it out.
Could you please guide me how to set?

137676-aa.png

Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,449 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,636 Reputation points Microsoft Employee
    2021-10-08T16:56:41.847+00:00

    @Tin, Nilar Win Thank you for posting your question on Microsoft Q&A

    Please check if the data source exists . You can verify the name of the data source by querying sys.external_data_sources
    The tutorial below has the step with more details

    https://learn.microsoft.com/en-us/sql/relational-databases/import-export/examples-of-bulk-access-to-data-in-azure-blob-storage?view=sql-server-ver15

    Hope that will help

    Regards,
    Oury