export/import mapping in copy activity

Question

Hello,

Have a mapping built in copy activity with 240 columns mapped. Creation took some time.
I wonder is it a way to export this to let say json or other format to reuse it later?
Sometimes happen a schema change or espacially altering data types causes the mappings crashed.
I want to avoid rebuilding this again.

Answer 1

Hi @BartoszWachocki-4076,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

The pipeline code can be seen as a JSON that allows editing and copying the contents. This JSON has all the column mappings chosen and the entire contents or partial contents from this JSON can be copied into a new pipeline which retains the mappings. Below GIF shows complete mapping copied into a new pipeline.

Hope this helps! Please let us know for further queries and we will be glad to assist.