#54. Azure Data Factory - Demo of tumbling window trigger

In this video, you can see the tumbling window trigger working. We use the tumbling window trigger to read records from an azure SQL table based on tumbling window start time and write to a csv file.

[Rafian]

Superb..always be your fan..such a unique way of teaching..you are teaching as if you are personally paying attention to every student.

[tanavs]

Very helpful and nicely taught, would have been great if the video quality was not compromised.
Now I feel confident with Tumbling window concept, kudos to you, thanks heaps :).
You hammered it by using real time scenarios.

[sid]

Simplicity in your video speaks a lot about your expertise on this subject. Thanks :) I like this tumbling window option in terms of dependencies too. The tumbling windows can be rerun for specific window when something went wrong in the past run makes it more reliable.

[junaidmalik]

That was a amazing demo, Thank you mam for taking out some time to create beautiful/useful content like this. cant tell you how much it helps for someone who wants to learn.

[TheTruthSpeaker]

Even a schedule trigger can be set to run every 5 minutes. We can set a variable to capture the utc time the moment the pipeline gets triggered and then utilise that time in the query.

[bsreddy]

Hi Madem,

Can you please let us know what are the possible errors will get in real time and do some videos on it. That would be helpful for us. Thanks!

[madinayokubbaeva]

Hi Mam, Thank you for your tutorials. I was wondering why you are using Shouldn't you use the ? What I mean is that if you schedule the trigger once in a week schedule, you may skip the newly inserted rows that are added in between triggers' run time. Thank you for your response

[LearnerMsbi]

Thanks for this video. Pls show how can we implement dependant triggers.

[ganeshsp]

Can you post what would be the WindowstartTime and WindowEndtime value.

[pankajmittal]

Mam one question, tumbling window pick the window start time when it started... or it picks the window start time from the previous finished job.

[ShivaKumar-rrtq]

Hi, I have a requirement to process files on daily basis I am using tumbling window. Can I pass tumbling window trigger time as a pipeline parameter to dataflow parameter in last modified date under dataflow source settings. If yes, please let me know how.

[battulasuresh]

Let's say u are interested 2 records at 4:16 pm
Your window current period is 4:17 window start And to 4:22 window end
Then 4:16 which is load datetime not falling between your 4:17 and 4:22
How the select query will return records