How to Use Bulk Insert to load File From Azure Blob Storage to Azure SQL Database Table TSQL BULK

How to Use Bulk Insert to load File From Azure Blob Storage to Azure SQL Database Table TSQL BULK | ADF Tutorial 2022, in this video we are going to learn How to Use Bulk Insert to load File From Azure Blob Storage to Azure SQL Database Table TSQL BULK | ADF Tutorial 2022, Azure Data Factory Step by Step - ADF Tutorial 2022 - ADF Tutorial 2022 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2022.

Script:
How to use Bulk Insert to load file from Azure Blob Storage to Azure SQL Database Table - TSQL BULK INSERT
1) Create Mater Key
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'test1223$';

2) Create credential by using SAS
CREATE DATABASE SCOPED CREDENTIAL blobcred
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = 'sv=2020-08-04&ss=bfqt&srt=sco&sp=rwlacupitfx&se=2022-02-18T04:03:59Z&st=2022-02-16T20:03:59Z&spr=https&sig=hLRC3OeyuHZhxjEl1dd41a1CqsxroTqX4EAm4axPCUw%3D';

3) Create External DataSource by using credentials

CREATE EXTERNAL DATA SOURCE dstechbrothers1
WITH (
TYPE = BLOB_STORAGE,
CREDENTIAL = blobcred
);

4) Create table and load data by using Bulk insert
drop table [dbo].[TotalSale]
CREATE TABLE [dbo].[TotalSale](
[id] [int] NOT NULL,
[SalePersonFName] [varchar](100) NULL,
[SalePersonLName] [varchar](100) NULL,
[ProductName] [varchar](100) NULL,
[ItemsSold] [int] NULL,
[SoldPrice] [float] NULL,
[SoldDate] [date] NULL,
[City] [varchar](100) NULL,
[State] [varchar](100) NULL,
[Country] [varchar](100) NULL,
[Region] [varchar](100) NULL
)

BULK INSERT [dbo].[TotalSale] FROM
WITH (DATA_SOURCE = 'dstechbrothers1', FIRSTROW = 2, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')

Select * From [dbo].[TotalSale]

Azure Data Factory Tutorial for beginners
Azure Data Factory Tutorial 2022
Step by step Azure Data Factory Tutorial
Real-time Azure Data Factory Tutorial
Scenario-based training on Azure Data Factory
Best ADF Tutorial on youtube

#AzureDataFactory #ADFTutorial2022

[zb]

This video was incredibly simple and solved a problem I've been struggling with in moments. Thank you for making it!

[Mr_Whipple]

Extremely good video thank you for providing such a concise and easy to follow guide.

[azurelearner]

Great!! Best videos on ADF covering almost all the concepts and are very easy to understand

[prateekbhardwaj]

just curious why u shoot screenrecording in massive 4k format?

[prajaktapatil]

Hi . Why do we need to create master key ? I don’t see it getting reutilise? And what if forget this master key ? How will it affect ?

[AvanyaStories]

Cannot bulk load because the file "tt1/tt.csv" could not be opened. Operating system error code 5(Access is denied.).