Forum Discussion
Parameters to fabric pipeline
- 7 months ago
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')}
Hi Ka13
I would suggest to keep all the parameter related inputs (HireDate, fromDate, toDate) in Pipeline-1 itself along with schema and table names, pass it to Pipeline-2. Pipeline-2 will just do the copy data or any activity.
This will be cleaner approach with one point for all parameters and keeps the second pipeline more reusable for only copy.
If this post helps, please accept this as a solution. Appreciate your kudos.
Thanks,
pallavi_r
Thanks Pallavi