NEW Azure Channel9 Post: Load data from Azure Blob storage into Azure SQL | Data Exposed

Channel9 Posts 0 Comments

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

Link to Channel9