Episode
Load data from Azure Blob storage into Azure SQL
In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show one way for loading data from Azure Blob storage into Azure SQL Database. For more info, see https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azuresqldb-current&WT.mc_id=dataexposed-c9-niner
[00:25] Background
[01:25] Azure SQL Notebook in Azure Data Studio
[02:06] Step 1: Create a table and schema
[02:20] Step 2: Create a master key
[02:37] Step 3: Create a database scoped credential
[03:16] Step 4: Create an external data source to the container
[04:15] Step 5: Bulk insert a single file and tips
[06:18] Summary
In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show one way for loading data from Azure Blob storage into Azure SQL Database. For more info, see https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azuresqldb-current&WT.mc_id=dataexposed-c9-niner
[00:25] Background
[01:25] Azure SQL Notebook in Azure Data Studio
[02:06] Step 1: Create a table and schema
[02:20] Step 2: Create a master key
[02:37] Step 3: Create a database scoped credential
[03:16] Step 4: Create an external data source to the container
[04:15] Step 5: Bulk insert a single file and tips
[06:18] Summary
Have feedback? Submit an issue here.