How to pass Tumbling Window parameters to a Data Factory pipeline in the Data Factory UI?

Question

I have defined a pipeline in Azure Data Factory with a Tumbling Window trigger, as seen below:

I would like for my activities to receive the Tumbling window parameters (trigger().outputs.windowStartTime and trigger().outputs.windowEndTime) however I did not find any examples in the documentation showing how to do this in the UI.

Question

How can I pass the Tumbling Window parameters to a Data Factory pipeline in the Data Factory UI?

Answer 1

This is because you set @trigger().outputs.windowStartTime and @trigger().outputs.windowEndTime in the variable. In fact, you should set them in the parameter, like this:

Please let me know if still facing issue.

Answer 2

This answer is out of date. Parameters can be added directly in the UI - see my answer above.

Note: You cannot pass the Tumbling Windows parameters to a Data Factory pipeline in the ADF UI.

You need to pass the tumbling window parameters by following steps:

First create a Tumbling window trigger as per your requirement.

On the bottom left corner, you will find the "Triggers" tab => Click on Triggers and select the created trigger and click on "Code" and replace the parameters.

To use the WindowStart and WindowEnd system variable values in the pipeline definition, use your "MyWindowStart" and "MyWindowEnd" parameters, accordingly.

For more details, refer "MSDN" thread, which addressing similar issue.

Hope this helps.

Answer 3

Assuming the pipeline that you're triggering is already paramaterised then you're nearly there.

When adding the trigger you'll see a second screen to pass parameters from the trigger.

You can then add your functions prefixed with @. So:

@trigger().outputs.windowStartTime
@trigger().outputs.windowEndTime

If you need to call a function on the parameter before you pass it you can do that too

@addHours(trigger().outputs.windowEndTime,1)