Snowflake shows task schedules in the account timezone, not yours

I set up a chain of scheduled tasks in Snowflake that were supposed to run at 02:00 local time. The next morning I checked INFORMATION_SCHEMA.TASK_HISTORY to confirm the run, and the first scheduled entry showed 2026-04-01 17:00:00.000 -0700. Panic — did I mess up the cron? Are the tasks even active?

Turns out the tasks were fine. My Snowflake account defaults its timezone to America/Los_Angeles, and the Task History view renders every timestamp in that zone. 2026-04-01 17:00:00 -0700 is just 2026-04-02 02:00:00 Europe/Berlin dressed up in PDT. The -0700 was literally sitting there telling me, and I walked right past it.

Lesson: check SHOW PARAMETERS LIKE 'TIMEZONE' IN ACCOUNT; before you lose an hour debugging — or set it to something sensible like Europe/Berlin or UTC so the history reads naturally.