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

Channel 9

English - April 23, 2020 16:00 - 6 minutes - 6.32 MB - ★★★★ - 38 ratings
Technology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed

Previous Episode: Entity Framework Core Part 4 | Visual Studio Toolbox

Next Episode: Source Link - Debug Third-Party Libraries | The Xamarin Show | The Xamarin Show

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