Bird
Raised Fist0
SnowflakeConceptBeginner · 3 min read

What is Task in Snowflake: Definition and Usage

A task in Snowflake is a way to schedule and automate SQL statements or procedural logic to run at set times or after other tasks complete. It helps manage workflows by running commands automatically without manual intervention.
⚙️

How It Works

Think of a task in Snowflake like a kitchen timer that you set to remind you when to do something. Instead of you remembering, the timer automatically triggers an action. In Snowflake, a task runs SQL commands or procedures on a schedule or when another task finishes.

Tasks can be linked together in a chain, so one task starts after another ends, like dominoes falling in order. This helps automate complex workflows, such as loading data, transforming it, and then updating reports, all without needing someone to run each step manually.

💻

Example

This example creates a simple task that runs every hour to insert the current timestamp into a table called task_log. It shows how to define and start a task.

sql
CREATE OR REPLACE TABLE task_log (run_time TIMESTAMP);

CREATE OR REPLACE TASK hourly_task
  WAREHOUSE = my_warehouse
  SCHEDULE = 'USING CRON 0 * * * * UTC'
AS
  INSERT INTO task_log VALUES (CURRENT_TIMESTAMP);

ALTER TASK hourly_task RESUME;
Output
Task 'hourly_task' created and started. It will insert the current timestamp into 'task_log' every hour.
🎯

When to Use

Use Snowflake tasks when you want to automate repetitive SQL operations without manual effort. Common uses include:

  • Regularly loading or refreshing data from external sources.
  • Running data transformation steps on a schedule.
  • Triggering dependent processes in a specific order.
  • Maintaining data pipelines that require timed or event-driven execution.

Tasks save time and reduce errors by ensuring processes run reliably and on time.

✅

Key Points

  • Tasks automate SQL commands on schedules or after other tasks.
  • They can be chained to create workflows.
  • Tasks run using a specified warehouse for compute resources.
  • They help keep data pipelines and processes running smoothly without manual steps.
✅

Key Takeaways

A Snowflake task automates SQL execution on a schedule or after other tasks.
Tasks can be chained to build automated workflows.
They use compute warehouses to run commands without manual intervention.
Tasks are ideal for scheduling data loads, transformations, and pipeline steps.