Bird
Raised Fist0
SnowflakeHow-ToBeginner · 3 min read

How to Suspend a Task in Snowflake: Simple Steps

To suspend a task in Snowflake, use the ALTER TASK <task_name> SUSPEND; command. This pauses the task's scheduled execution until you resume it.
📐

Syntax

The syntax to suspend a task in Snowflake is simple. You use the ALTER TASK command followed by the task name and the SUSPEND keyword.

  • ALTER TASK <task_name> SUSPEND;: Suspends the specified task.

This command stops the task from running on its schedule but keeps it defined in your system.

sql
ALTER TASK my_task SUSPEND;
💻

Example

This example shows how to suspend a task named daily_data_load. After running this command, the task will stop running until resumed.

sql
ALTER TASK daily_data_load SUSPEND;
Output
Statement executed successfully.
⚠️

Common Pitfalls

Common mistakes when suspending tasks include:

  • Trying to suspend a task that does not exist, which causes an error.
  • Not having the required privileges to alter the task.
  • Confusing SUSPEND with DROP, which deletes the task instead of pausing it.

Always check the task name and your permissions before suspending.

sql
/* Wrong: Drops the task instead of suspending */
DROP TASK daily_data_load;

/* Right: Suspends the task without deleting it */
ALTER TASK daily_data_load SUSPEND;
📊

Quick Reference

CommandDescription
ALTER TASK SUSPEND;Pauses the task's scheduled execution.
ALTER TASK RESUME;Resumes a suspended task.
SHOW TASKS;Lists all tasks and their statuses.
✅

Key Takeaways

Use ALTER TASK SUSPEND; to pause a task in Snowflake.
Suspending a task stops its schedule but keeps it defined for later use.
Ensure you have the right permissions and the task exists before suspending.
Do not confuse suspending a task with dropping it, which deletes the task.
Use SHOW TASKS; to check the status of your tasks.