Blog Post

Azure SQL Blog
1 MIN READ

Load data from Azure Blob storage into Azure SQL | New Data Exposed episode

Anna Hoffman's avatar
Anna Hoffman
Icon for Microsoft rankMicrosoft
Apr 23, 2020
Curious how loading data in Azure SQL Database is different than SQL Server? In this short episode, I walk through loading a single file (located in Azure Blob storage) into Azure SQL Database. This ...
Published Apr 23, 2020
Version 1.0
Anna Hoffman's avatar
Anna Hoffman
Icon for Microsoft rankMicrosoft
May 10, 2021

Try following along with this example: Exercise - Load data into Azure SQL Database - Learn | Microsoft Docs

 

The location "LOCATION = 'https://test.blob.core.windows.net/data/Data1/',"  should go to the container where the data is stored. Then in the bulk insert "FROM '/data/Data1/test.csv'" it should go from the container to the file. Right now your command is looking in "https://test.blob.core.windows.net/data/Data1//data/Data1/test.csv'. You may also have an extra '/'. Hope that helps