{ "name": "pipeline1", "properties": { "activities": [ { "name": "Copy data1", "type": "Copy", "dependsOn": [], "policy": { "timeout": "7.00:00:00", "retry": 0, "retryIntervalInSeconds": 30, "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "source": { "type": "DelimitedTextSource", "additionalColumns": [ { "name": "currentdate", "value": { "value": "@utcnow()", "type": "Expression" } }, { "name": "tablename", "value": "testtable" }, { "name": "partitionid", "value": "1" } ], "storeSettings": { "type": "AzureBlobStorageReadSettings", "recursive": false }, "formatSettings": { "type": "DelimitedTextReadSettings" } }, "sink": { "type": "AzureTableSink", "azureTableInsertType": "merge", "azureTablePartitionKeyName": "PartitionKey", "azureTableRowKeyName": "RowKey", "writeBatchSize": 10000 }, "enableStaging": false, "translator": { "type": "TabularTranslator", "mappings": [ { "source": { "name": "partitionid", "type": "String" }, "sink": { "name": "PartitionKey", "type": "String" } }, { "source": { "name": "tablename", "type": "String" }, "sink": { "name": "RowKey", "type": "String" } }, { "source": { "name": "currentdate", "type": "String" }, "sink": { "name": "LoadTime" } } ], "typeConversion": true, "typeConversionSettings": { "allowDataTruncation": true, "treatBooleanAsNumber": false } } }, "inputs": [ { "referenceName": "DelimitedText1", "type": "DatasetReference" } ], "outputs": [ { "referenceName": "AzureTable1", "type": "DatasetReference" } ] } ], "annotations": [] } }