How to get Azure Data Factory Tumbling Window Trigger to work with Daylight Savings Time

Alyssa Hornung 1 Reputation point
2022-05-20T22:30:08.073+00:00

We have a set of about 20 tumbling window triggers that are set to run at specific intervals 6 hours apart. It is critical that they run at the designated time (think 5am and 11am, and so on) We have them set up so that they are self-dependent and dependent on a connection check trigger.

Our problem arises when daylight savings comes around. Tumbling window triggers only work in UTC and when the clock changes in our time zone, the times they are triggered change by an hour(forward or back depending on the time of year). This causes data to be late to it's destination and forces our team to manually deploy new triggers every time around daylight savings time.

I am wondering if there is a better way to work around daylight savings time as Tumbling Window Triggers do not support any time zone other than UTC and deploying new triggers every time is not an effective solution.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,640 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.