export/import mapping in copy activity

Question

export/import mapping in copy activity

braxx 461

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 accepted by question author

0 additional answers

Your answer

Answer 1

HarithaMaddi-MSFT 10,151

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.

HarithaMaddi-MSFT 10,151 Reputation points

2020-10-06T08:38:37.217+00:00

Hi @BartoszWachocki-4076,

We have not received a response from you. Please let us know if above answer is helpful. Otherwise, we will continue to engage with you on the question.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
HarithaMaddi-MSFT 10,151 Reputation points

2020-10-07T06:42:00.073+00:00

Hi @BartoszWachocki-4076,

We still have not heard back from you. Following up to check if above answer is helpful. Otherwise, we will continue to engage with you on the question.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
braxx 461 Reputation points

2020-11-10T16:20:54.097+00:00

Sorry for late reply. You fully answered by question . Thanks a lot

Share via

export/import mapping in copy activity

0 additional answers

Your answer