snowflake-create-task

SkillDatabases & data

Consult Snowflake CREATE TASK parameter reference before generating any CREATE TASK DDL.

Available today. Use it from your connected AI after setup.

No other account needed.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the snowflake-create-task skill

What this skill tells your AI

The instructions your AI receives, as published by gyrus-dev/frosty in skills/snowflake-create-task/SKILL.md and read by ahel’s review.

Before writing a CREATE TASK statement:

Read references/parameters.md to review all available parameters and their defaults.
For each parameter, decide whether the user's request implies a non-default value.
Include only the parameters that differ from the default or that the user explicitly requested.
Never use CREATE OR REPLACE — always use CREATE TASK IF NOT EXISTS where supported.
Newly created tasks are always suspended; remind the user to run ALTER TASK <name> RESUME after creation.
Root and standalone tasks require a SCHEDULE; child tasks (those with AFTER) must not have one.
Prefer serverless compute (omit WAREHOUSE, set USER_TASK_MANAGED_INITIAL_WAREHOUSE_SIZE) unless the user explicitly requests a named warehouse.
Only one task should consume from any given stream; advise creating separate streams for multiple consumers.
AUTOCOMMIT must be TRUE for DML statements executed inside a task.

Advanced