In the above command, you have to use your Shared Access Signature(SAS) token of your Azure blob container.WITH IDENTITY = 'SHARED ACCESS SIGNATURE', Otherwise, execute the below command to create a credential:ĬREATE DATABASE SCOPED CREDENTIAL MyAzureCredential Skip this step if you have enabled the public access for your blob container. The next step is to create a database scoped credential.
Create a Master key for encryption purposes using the below query:ĬREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Your Password'.Open the Query Editor window of the Azure SQL database.
Now follow the below steps to bulk insert the data from the CSV file into the Azure SQL database table: Once executed successfully, you will see an output like below in the image: