thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Snowflake Task

A Snowflake object that runs a SQL statement, procedure call or Snowflake Scripting block on a schedule or after a predecessor task, forming DAGs.

Definition

Tasks can use a user-managed warehouse or serverless compute. A WHEN SYSTEM$STREAM_HAS_DATA('s') condition skips runs when there is nothing to process. New tasks are created suspended and must be resumed.

Example

CREATE TASK t1 WAREHOUSE = etl_wh SCHEDULE = '5 MINUTE' WHEN SYSTEM$STREAM_HAS_DATA('orders_stream') AS MERGE INTO ...;

Exam tip

Tasks are created suspended; run ALTER TASK ... RESUME (resume child tasks before the root).

Related terms