24. Copy Data Activity in Azure data factory Continuation

In this video, I discussed about settings and User Properties in Azure data factory
Link for Azure Functions Play list:
• 1. Introduction to Azu...
Link for Azure Basics Play list:
• 1. What is Azure and C...
Link for Azure Data factory Play list:
• 1. Introduction to Azu...
#Azure #ADF #AzureDataFactory

[@47shashank47]

Sir....Thanks for proving such great knowledge. .. Your content is amazing .

[@arghyanandy6469]

Great Content. I'm learning from your ADF video playlist :)

[@WafaStudies]

Thank you 😊

[@SouravDas-e1l]

superb content

[@Amitexpresses]

Sir u are the best

[@Jatin_singh7]

Thankyou for the video 😊

[@sonamkori8169]

Thank You Soooo much .... Sir

[@WafaStudies]

Welcome 😊

[@SiddhikRam_Rockz]

@@WafaStudies Hi Bro
please reply.

[@meelookaru2888]

hi, if you add any new video about staging location as you mentioned please add that video link in description.

[@vikasgupta6888]

Looking one suggestion. I am getting the same error "Operation on target Copy data into Target failed: ErrorCode=TypeConversionFailure,Exception occurred when converting value '2150002867256' for column name 'Col1' from type 'String' (precision:255, scale:255) to type 'Int32' (precision:, scale:). Additional info: Value was either too large or too small for an Int32."
My source (Synapse) column type (Varchar (249) and Target (Couchbase) column type are same STRING. But not sure the error for the value '2150002867256' . Its a ODBC connection between Synapse and Couchbase. And doing COPY Activity in ADF

[@WritingWithShreya]

Please tell me how to write a precopy script to delete data of today before loading the incremental data

[@dataguys2192]

How does User properties work with Copy activity in a dynamic mode? Or is it only used in hardcoded modes?

[@pavankumar-si5qr]

Hi Maheer, thanks for the video. Your videos are too helpful. Is there any way to check the count of number of files copied from source to destination when using copy activity. If yes could you please post me the steps to do that.

[@SaurabRao]

you can click the spectacle icon during debug or when triggered for the real time row counts to come up

[@thesujata_m]

How to copy data from azure data lake to sql server?

[@akshadagawali3987]

how to add mapping dynamically ?

[@WafaStudies]

There is a video on that. Could u pls search as "dynamic column mapping in adf" in youtube. U see my video

[@pavaninti1530]

If copy activitiy is performed multiple times,Is it going to replace the already existing data in the output or will it append to the existing one? Appreciate your help on this..

[@gawlianilnrayan]

new entry will be created I guess

[@SanjayKewat]

Hi Wafa,
Could you please help me store the below data into a table of one row in SQL?
Table Schema
MPR,ReadDate,Block1,ReadType1,Block2,ReadType2,Block3,ReadType3,Block4,ReadType4,Block5,ReadType5,Block6,ReadType6
Explaination :
Block1 ==> 00:30 and kWh value goes into this column
Block2 ==> 01:00 and kWh value goes into this column
Block3 ==> 01:30 and kWh value goes into this column
Block4 ==> 02:00 and kWh value goes into this column
Block5 ==> 02:30 and kWh value goes into this column
Block6 ==> 03:00 and kWh value goes into this column
Here is Data :
MPR,ReadDatetime,kWh,ReadType
111,04/11/2020 00:30,100,Actual
111,04/11/2020 01:00,100,Actual
111,04/11/2020 01:30,100,Actual
111,04/11/2020 02:00,100,Actual
111,04/11/2020 02:30,100,Actual
111,04/11/2020 03:00,100,Actual
please suggest to me how can I achieved this.