11. Scheduling in SnowFlake#

  • Scheduling in Snowflake is called Tasks

11.1. Creating a Task#

CREATE OR REPLACE TASK TASK1 Warehouse = COMPUTE_WH SCHEDULE = '1 Minute'  --Needs to be in minutes AS  //Single SQL Statement here

11.2. Show Tasks#

SHOW TASKS

  • By Default,Tasks are suspended.

  • You have to start them manually

11.3. Starting a Task#

ALTER TASK TASK1 RESUME;

11.4. Ending a Task#

ALTER TASK TASK1 SUSPEND;

11.5. Using CRON in Schedule#

  • SCHEDULE=’USING CRON ***** UTC’

    • First * - Minute

    • Second * - Hour

    • Third * - Day of Month (1-31)

    • Fourth * - Month

    • Fifth * - Day of week (0-6)

11.5.1. Use cases of CRON#

  • Every min - ‘ USING CRON ****** UTC’

  • Every day at am - ‘USING CRON 0 6 * * * UTC’

  • Every hour starting at 9am end at 5pm on Sundays - ‘USING CRON 0 9-17 ** SUN America/Los-angelis’