Load data from Azure Blob storage into Azure SQL | Data Exposed
Channel 9 - Un pódcast de Microsoft
Categorías:
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