Forum Discussion
Helper IIParameters to fabric pipeline
Hello Ka13
I suggest you set up pipelines only with the required parameters.
Pipeline 1 parameters:
- Schema
- Table
Pipeline 2 parameters:
- Schema
- Table
- HireDate
- Fromdate
- ToDate
Pipeline 3 (the invokiing pipeline or the parent pipeline):
Insert two Invoke Pipeline activities.
Pipeline 3 parameters:
- Schema
- Table
- HireDate
- Fromdate
- ToDate
In the setting of each Invoke Pipeline activities, pass the pipeline3 parameters like so
Schema String @pipeline().parameters.Schema
HireDate String @{formatDateTime(pipeline().parameters.HireDate, 'yyyy-MM-dd')}
Super UserHi Ka13,
I agree with pallavi_r, passing them into the first pipeline, and then having the first pipeline execute the second pipeline is a clean approach.
What could also be done is having a master "orchestration" pipeline that takes all the parameters, and then it runs the 3 pipelines only passing in what those pipelines need as parameters.
