How to Create Tumbling Window Trigger in Azure Data Factory for Real Time Scenario

 Issue: How to Create Tumbling Window Trigger in Azure Data Factory for Real-Time Scenario.

In this article, we are going to learn how to create a tumbling window trigger in the Azure data factory for the real-time scenario, in this demo we will create a pipeline from the scratch and then will add the tumbling window trigger.

Create a pipeline:

Open your Azure data factory studio, go to the author tab, click on + sign, find and drag the copy data activity, go to the source tab and then click on the + New button to create a new source dataset.

Find and select the Azure SQL database, then click on continue.

Name your dataset, select the linked service, select none for import schema, then click on ok

Open your SQL Server Management Studio and create a store procedure.

Next, back to the Azure Data Factory, select the store procedure.

Go to the sink tab and click on the + New button to create a new Sink Dataset.

Select Azure SQL Database and then click on continue.

Name your dataset, select the linked service, select the destination table where we will write the data, select none for import schema and then click on ok.

Next, Create parameters on the pipeline level, click on the white canvas, then go to the parameter tab and click on the + New button.

  

Create two parameters one for the Pipeline Start date and the second for the pipeline end date and return back to the copy activity go to the source tab and map the parameters.

 

How to add Tumbling Trigger:

Click on the Add trigger button and the top of the dashboard, then select the New/Edit from the drop-down menu.

Click on create new, name the trigger, select the trigger type, define the trigger start date and time, define the recurrence, specify and end date and time, select start trigger on creation, and then click on ok.

Then provide the values and click on ok and then publish the trigger, here your tumbling trigger is ready, now go to the monitor tab and you will see the trigger performance.

Video Demo: How to Create Tumbling Window Trigger in Azure Data Factory for Real Time Scenario