20. Schema Mapping in Copy activity of ADF pipeline

[@azurelearner4055]

Simple and clear Explantion of schema mapping !! Thank you !!

[@sagardevara4174]

Really good stuff. Thanks for sharing!!

[@venkatpr9692]

Excellent lecture Annu Plz make more videos🦋🦋🦋

[@azurecontentannu6399]

Thankyou so much

[@fpchd]

thanks, this was very helpful!

[@ramrajendran8065]

Good one ✌️

[@azurecontentannu6399]

Thankyou so much 🙂

[@akrzha]

24:30 What if we have multiple arrays in the source?

[@joseangelmartinez308]

Hi Annu, this video was excellent! I was wondering, for the case of explicit mapping, when copying from hierarchical source to hierarchical sink, is it possible to add a column in the sink which is not present in the source? So for example, in your video, if you want to add a hardcoded column in your output JSON named ''status" and then fill it with value "active". Is it possible? And another questtion, can you build more complex sink structures based on the input data? For example, let's imagine that you need to have the 'fisrt_name' and 'last_name' from the source to be included in the output JSON within a JSON object named 'person_name', like: 'person_name' : {'firstname' : 'xxx', 'last_name': 'yyy'}, could you do that with the mapping? Or would we need a dataflow for more complex activities?

[@CGlassmates]

Thank you so much😊

[@azurecontentannu6399]

Thankyou for watching

[@ATHARVA89]

i have upwards of 500 columns in source xml files, which im trying to copy. But its giving me character exceeds limit of 8512 error. Any workaround in this case

[@sudhanshuranjan8526]

Hi ma’am Can we do this copy activity for delta table as sink.

[@sourabhsingh1315]

Hi Mam, How to join a column from another table in ADF.

[@t-rexrex9535]

So who do you copy multiple csv file without headers and map them to existing tables in Azure without the pop_0 error?

[@BittuBhowmick89]

I am trying to copy data from one sql table to another. but when i try to do import schema, i am not getting option to change the data type. pls guide me to undertstand the reason behind this

[@sanketchakane7745]

my use case is if corrupt input data occurs then I want to log that data in sql table without using upsert, fault tolerance, enable logging or data flow , is there another way eg if string data comes instead of int then i want to skip that and record in table and dont interrupt rest run

[@azurecontentannu6399]

Why not fault tolerance? It's the best and easiest way for this scenario

[@ComedyXRoad]

at 8:47 how table name is created we have used auto create but not given any table name