How to use Azure Data Explorer Activity in Azure Data Factory to Ingest CSV File from Blob Storage
How to use Azure Data Explorer Activity in Azure Data Factory to Ingest CSV File from Blob Storage | ADF Tutorial 2021, in this video we are going to learn How to use Azure Data Explorer Activity in Azure Data Factory to Ingest CSV File from Blob Storage | ADF Tutorial 2021, Azure Data Factory Step by Step - ADF Tutorial 2021 - ADF Tutorial 2021 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2021
//create Table and Insert Sample Data in Azure Data Explorer DB for Testing
//.drop table TotalSale
.create table TotalSale (
id: int
,SalePersonFName: string
,SalePersonLName : string
,ProductName : string
,ItemsSold : int
,SoldPrice :real
,SoldDate: date
,City : string
,State : string
,Country : string
,Region : string
)
.ingest into table TotalSale
h'https://techbrothersstorage.blob.core...
;
//Insert data
.ingest inline into table TotalSale |
11,Tamara,Tony,Cell Phone,2,1200,2015-03-03,Frankfurt,Hesse,Germany,Europe
9,Petra,Henry,TV,10,5000,2015-04-08,Paris,Île-de-France,France,Europe
3,Christy,Ladson,TV,3,1600,2015-04-02,High Point,NC,USA,North America
7,Chirag,Patel,Cell Phone,5,1500,2015-06-23,AhmadAbad,Gujrat,India,Asia
2,M,Raza,Cell Phone,2,800,2015-07-15,Charlotte,NC,USA,North America
5,Najaf,Ali,Computer,1,300,2015-06-20,Karachi,Sindh,Pakistan,Asia
6,Sukhjeet,Singh,TV,2,900,2015-06-21,ChandiGar,Punjab,India,Asia
4,John,Rivers,Laptop,5,2400,2014-03-09,Jersey City,NJ,USA,North America
8,Aleena,Aman,Laptop,2,800,2015-05-25,Lahore,Punjab,Pakistan,Asia
10,Rita,Roger,Laptop,7,2100,2015-04-11,Paris,Île-de-France,France,Europe
1,Aamir,Shahzad,TV,1,700,2015-07-15,Charlotte,NC,USA,North America
12,aamir,Shahzad,TV,1,7000,2015-07-15,Charlotte,NC,USA,North America
10,Rita,Roger,Laptop,7,2100,2015-04-11,Paris,Île-de-France,France,Europe
//link for control commands in Azure Data Explorer Cluster
Azure Data Factory Tutorial for beginners
Azure Data Factory Tutorial 2021
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 #ADFTutorial2021
Watch video How to use Azure Data Explorer Activity in Azure Data Factory to Ingest CSV File from Blob Storage online without registration, duration hours minute second in high quality. This video was added by user TechBrothersIT 21 December 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,450 once and liked it 18 people.