Search code examples
cronsnowflake-cloud-data-platform

Create Task in Snowflake in IST timezone

The documentation says USING CRON <expr> <time_zone> but when I try to do something like 'USING CRON 20 01 * * * IST' I'm getting an error that says Invalid schedule was specified. "IST" is not a recognized time zone. Please specify time zones accepted by the TIMEZONE parameter.

Solution

  • 'USING CRON 20 01 * * * Asia/Kolkata' is the format you're looking for. This is how it's written according to this page