topic Parameters to fabric pipeline in Data Engineering

Parameters to fabric pipeline

Ka13 — Fri, 27 Feb 2026 15:50:19 GMT

I had a question about passing the parameters to the pipeline.

Can we pass the parameters HireDate, fromdate and todate only in the 2nd pipeline? , or to pass all parameters in the main pipeline which will have Invoke pipeline of 2 pipelines?

1. 1st pipeline will invoke the json which has the schema and table.

2. To Invoke the other pipeline after the 1st pipeline, and pass the the above values of schema and table to 2nd pipeline and also to pass the values - HireDate, fromdate and todate in the Copy Activity,

Below queries to add in the Copy Activity

Re: Parameters to fabric pipeline

pallavi_r — Wed, 04 Feb 2026 05:40:43 GMT

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

Re: Parameters to fabric pipeline

deborshi_nag — Wed, 04 Feb 2026 10:53:44 GMT

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')}

Re: Parameters to fabric pipeline

tayloramy — Wed, 04 Feb 2026 14:51:57 GMT

Hi @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.

Re: Parameters to fabric pipeline

Ka13 — Thu, 05 Feb 2026 06:04:14 GMT

Thanks Pallavi

Re: Parameters to fabric pipeline

Ka13 — Thu, 05 Feb 2026 06:04:49 GMT

Thanks @tayloramy

Re: Parameters to fabric pipeline

Ka13 — Thu, 05 Feb 2026 06:05:13 GMT

Thanks @deborshi_nag