{ "name": "pl_LoadDateBatches", "properties": { "description": "load data in date batches", "activities": [ { "name": "set_NumBatches", "type": "SetVariable", "dependsOn": [], "userProperties": [], "typeProperties": { "variableName": "v_NumBatches", "value": { "value": "@string(div(pipeline().parameters.pdaysBack, pipeline().parameters.pdaysBatches))", "type": "Expression" } } }, { "name": "Make 0 to NumBatches", "type": "SetVariable", "dependsOn": [ { "activity": "set_NumBatches", "dependencyConditions": [ "Succeeded" ] } ], "userProperties": [], "typeProperties": { "variableName": "range", "value": { "value": "@range(1,int(variables('v_NumBatches')))", "type": "Expression" } } }, { "name": "For each interval", "type": "ForEach", "dependsOn": [ { "activity": "Make 0 to NumBatches", "dependencyConditions": [ "Succeeded" ] } ], "userProperties": [], "typeProperties": { "items": { "value": "@variables('range')", "type": "Expression" }, "isSequential": false, "activities": [ { "name": "pl_loadPhysical", "description": "Multiply by pdays_batches", "type": "ExecutePipeline", "dependsOn": [], "userProperties": [], "typeProperties": { "pipeline": { "referenceName": "pl_loadPhysical", "type": "PipelineReference" }, "waitOnCompletion": true, "parameters": { "date": "@mul(item(),pipeline().parameters.pdaysBatches)" } } } ] } } ], "parameters": { "pdaysBack": { "type": "int", "defaultValue": 20 }, "pdaysBatches": { "type": "int", "defaultValue": 4 } }, "variables": { "v_NumBatches": { "type": "String" }, "range": { "type": "Array" } }, "folder": { "name": "Aspect/Test" }, "annotations": [] } }