20. Schema Mapping in Copy activity of ADF pipeline

In this video we learnt about Schema Mapping in Copy activity of ADF pipeline #adf #azuredatafactory #datafactory #azuresynapseanalytics #synapseanalytics #microsoft #cloud #cloudcomputing #dataengineer #dataengineering #dataengineeringessentials #azure #azurelearning #azurecontentannu

[@sagardevara4174]

Really good stuff. Thanks for sharing!!

[@azurelearner4055]

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

[@fpchd]

thanks, this was very helpful!

[@venkatpr9692]

Excellent lecture Annu
Plz make more videos🦋🦋🦋

[@azurecontentannu6399]

Thankyou so much

[@ramrajendran8065]

Good one ✌️

[@azurecontentannu6399]

Thankyou so much 🙂

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

[@sudhanshuranjan8526]

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

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

[@CGlassmates]

Thank you so much😊

[@azurecontentannu6399]

Thankyou for watching

[@akrzha]

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

[@sourabhsingh1315]

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

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

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

[@ComedyXRoad]

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