This page describes the steps needed to activate Azure SQL Managed Identity, which can be used to access the referenced Blob storage container for BULK INSERT operation.

Activating System assigned managed identity

In the Azure portal, navigate to SQL servers, and select the SQL server governing the designated SQL database:

Open

Navigate to section Identity and turn System assigned managed identity On:

Open

Granting access to the Blob container

Switch to the Blob container which is to be used for the data transfer and select Access Control IAM:

Open

Choose Role Assignments

Open

Click Add → Add role assignment

Open

In Role selection, choose Storage Blob Data Contributor

Open

In the Members tab, Assign access to: Managed identity and via the Select members link

Open

select the correct SQL server

Open

Click the buttons Select and Review + assign to finalize the role assignment.
When the assignment is complete, it is visible in the Notifications:

Open