Allow setting the timezone for slices
Currently slices run in UST, and if data sources are in other timezones, a simple DATEADD on the where clause will cause missed data when there is a DST chance.
Additionally, adding DATEADD on every source is error prone, especially if a server changes their timezone in the future
Allow us to set the timezone either on a pipeline level, a linked service level or a Dataset level -- any of these would do as long as ADF transparently translates SliceSlart and SliceEnd to the appropriate timezone
Santiago Obando Dordán commented
Please, we need the capability to select the timeZone at Pipeline and Linked Service level.
carl wharehinga commented
PLZ improve TZ UTC sux
pls improve TImezone
Matt Duguid commented
Same issue here in NZ, some items show as UTC time and some items as NZ time, very confusing when setting up triggers and troubleshooting when they dont run later.
Akash Mehrotra commented
* UTC not UST