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

From the creator

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 Follow Anna Hoffman and Jeroen ter Heerdt on Twitter at https://twitter.com/AnalyticAnna and https://twitter.com/JeroenterHeerdt. More Data Exposed: https://www.youtube.com/playlist?list=PLlrxD0HtieHieV7Jls72yFPSKyGqycbZR&WT.mc_id=dataexposed-c9-niner

Published 2020-04-23 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.