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