6. Copy Activity- Blob Storage to Azure SQL Database | Azure Data Factory

Copy Activity- Blob Storage to Azure SQL Database | Azure Data Factory
A small help to those who wanted to upgrade their skills on Microsoft skills in very easiest way.
#azure #sql #adf #sqlserver
#cloudcomputing
#azuredatafactory
#etl
#blobstorage
=====To Get More useful video's, please follow below links ======
1.) To learn Learn SQL Server Concepts, visit below playlist
• Learn SQL Server Concepts
2.) To learn SQL Server Clauses and Keywords, please visit below playlist
• SQL SERVER CLAUSE/KEYW...
3.) For SSIS Tutorial, follow below playlist
• SQL SERVER Integration...
4.) For SSRS tutorial, follow below playlist
• SSRS Tutorials
5.) Python Tutorials, follow below playlist
• Python for Data Engine...
6.) Azure Data Factory Playlist
• Azure Data Factory Tut...
7.) Power BI Concepts, Visit below playlist
• Power BI Concepts
8.) MS Excel and Google Sheets, follow below playlist
• MS Excel Concepts
=======My Favorite Study Materials you can check out =====
--Python Crash course :amzn.to/40gfFPr
--SQL Programming :amzn.to/40gqK2T
--MSBI Course : amzn.to/3Qxh94y
--Power BI Course :amzn.to/3QgimMl
=========Share, Support and Subscribe =========
Subscribe to my UA-cam channel :
/ @learnwithmrajput
Share and like the Facebook Page :
/ 212104595551052
Thank you for Watching
By SQL
By SQL Training Session
Disclaimer : the above links may be amazon affiliate links, which means if you go through it,
I may get some commission but please bear in mind, it won't charge you a single penny
..so if you like the content, keep watching and support my channel.

[@markayala7752]

thank you for tut
can i use 10gig text file in blob storage and move it to database ?

[@abanadeel918]

How to process very large csv file from blob to Sql database ? Is there any way to read file in chunk and transform and load to SQL database ?

[@ashutoshnayak6242]

Hello mam,
Keeping public network end point is good or we should keep it private while creating the azure data factory? Please tell.
Thank you.

[@nishant738]

Once data is copied, will that file be in the same source? How is it not processed again?

[@christiangonzales1330]

Good day! I keep getting this error message "Error code
2200
Failure type
User configuration issue
Details
Required property 'location' is missing in payload.
Source
Pipeline
testpipeline
I cant find the fix for the life of me. all my systems are eastus.

[@showbiz2381]

Good evening ma'am i want to split a column into two columns, if I have a number that is 10 digits I want to split it into num1 which has 5 digits, and num2 which has the other 5 digits. how do I do that in the Azure data factory?

[@LearnWithMRajput]

Hi, we can add one derived column transformation in data flow in azure data factory and can use the split function to provide the value of our newly created derived column.

[@showbiz2381]

@@LearnWithMRajput Ma'am is there any video lecture solving my use-case

[@showbiz2381]

ma'am split can only be used to delimitors but in my data there are no delimitors just a complete string

[@LearnWithMRajput]

Hey Dear, You can try using Substring instead of split function

[@showbiz2381]

@@LearnWithMRajput thank you ma'am it worked