QuestionQ54Verified/Architecture OverviewCopy linkReport a problemAsk AstroTutorSave questionHow does Snowflake handle a local-time change caused by daylight saving time for tasks?Choose twoAA task scheduled in a UTC-based schedule will have no issues with the time changes.BTask schedules can be designed to follow specified or local time zones to accommodate the time changes.CA task will move to a suspended state during the daylight savings time change.DA frequent task execution schedule like minutes may not cause a problem, but will affect the task history.EA task schedule will follow only the specified time and will fail to handle lost or duplicated hours.Show AnswerAnswerExplanationA 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.Learn moreSnowflake CREATE TASK documentationShow comments4Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion