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

Question

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?

Answer 1

@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