Snowflake Tasks Introduction (2026)

Official Snowflake documentation for Tasks — automated data pipeline scheduling.

Key facts surfaced (2026-05-19):

• Tasks run SQL commands or stored procedures on schedule or event trigger.
• Schedule options: SCHEDULE='60 MINUTES' interval syntax, or CRON expression: SCHEDULE='USING CRON 0 3 * * SUN America/Los_Angeles'.
• Event trigger: WHEN SYSTEM$STREAM_HAS_DATA('stream_name') for stream-based execution.
• Supports combined schedule + condition for interval runs only when conditions exist.
• Curriculum reference: composable CDP equivalent of AEP scheduled batch query for cron-based COPY statements (Module 2).