ADF复制管道-schemamapping参数 [英] ADF Copy pipeline - schemamapping parameter

问题描述

我们有ADF模板，客户可以使用它们将数据导入xyz系统.其中有一个复制任务.问题是每次我们加入客户时，我们都必须做一些手动工作来修复源和目标之间的架构和映射， 因为每个客户的数据都是不同的.

We have ADF templates that our customers can use to import their data into xyz system. There is a copy task in it. The problem is every time we onboard a customer, we have to do some manual work to fix the schema and mapping between source and destination, because every customers data is different.

是否有一种方法可以将模式/映射作为ADF管道中的参数注入，这样我们就不必进行手动工作了?

Is there a way to inject the schema/mappings as parameters in ADF pipeline, so that we dont have to do manual work?

谢谢

推荐答案

这是映射参数化的示例:

This is an example of mapping parameterization:

@Json('{"type": "TabularTranslator","columnMappings": {"Prop_0": "Prop_0","Prop_1": "Prop_1"}}')

以及模式参数化的示例:

and an example of schema parameterization:

@json('[{"name": "Prop_0","type": "String"},{"name": "Prop_1","type": "String"}]')

这篇关于ADF复制管道-schemamapping参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！