Forum Discussion

Ka13's avatar
Ka13
Icon for Helper II rankHelper II
7 months ago
Solved

Parameters to fabric pipeline

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 w...
data engineering
data pipeline
  • deborshi_nag's avatar
    deborshi_nag
    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')}

     

deborshi_nag's avatar
deborshi_nag
Icon for Super User rankSuper User
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')}