How does Snowflake handle a local-time change caused by daylight saving time for tasks?
A task scheduled with UTC is unaffected by daylight saving time because UTC has no daylight-saving adjustment. A cron schedule using a daylight-saving-observing time zone can run twice during a repeated hour or not run during a skipped hour; Snowflake does not automatically compensate for those duplicated or nonexistent local times.
Community Discussion