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

[@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.

[@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 ?

[@nishant738]

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

[@markayala7752]

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

[@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