How to get Azure Data Factory Tumbling Window Trigger to work with Daylight Savings Time
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.