ADF Copy Data Activity Mapping 动态内容使用指南

在 ADF (Azure Data Factory) 中，Copy Data Activity 的 Mapping 属性可以使用动态内容来定义。以下是使用动态内容的一些示例：\n\n1. 使用参数作为动态内容：\n\n"mapping": {\n "type": "TabularTranslator",\n "translator": {\n "type": "TabularTranslator",\n "mappings": [\n {\n "source": {\n "name": "@pipeline().parameters.sourceColumnName",\n "type": "String"\n },\n "sink": {\n "name": "targetColumnName",\n "type": "String"\n }\n }\n ]\n }\n}\n\n\n2. 使用函数作为动态内容：\n\n"mapping": {\n "type": "TabularTranslator",\n "translator": {\n "type": "TabularTranslator",\n "mappings": [\n {\n "source": {\n "name": "@concat('source_', formatDateTime(utcnow(), 'yyyyMMdd'))",\n "type": "String"\n },\n "sink": {\n "name": "targetColumnName",\n "type": "String"\n }\n }\n ]\n }\n}\n\n\n3. 使用变量作为动态内容：\n\n"mapping": {\n "type": "TabularTranslator",\n "translator": {\n "type": "TabularTranslator",\n "mappings": [\n {\n "source": {\n "name": "@variables('sourceColumnName')",\n "type": "String"\n },\n "sink": {\n "name": "targetColumnName",\n "type": "String"\n }\n }\n ]\n }\n}\n\n\n通过使用动态内容，可以根据参数、函数或变量的值来动态定义 Copy Data Activity 的 Mapping 属性，从而实现更加灵活和可重用的数据复制操作。