Skip to main content
Glama

Tasks Create Task

tasks_create_task

Create a scheduled or serverless Snowflake task from a SQL statement, optionally specifying database, schema, warehouse, and schedule. Use it to automate recurring SQL workloads.

Instructions

Create a scheduled or serverless task in Snowflake.

Input Schema

NameRequiredDescriptionDefault
databaseNoQuote names that aren't all uppercase, exactly as list tools return them.
scheduleNo
task_nameYesQuote names that aren't all uppercase, exactly as list tools return them.
warehouseNoQuote names that aren't all uppercase, exactly as list tools return them.
schema_nameNoQuote names that aren't all uppercase, exactly as list tools return them.
if_not_existsNo
sql_statementYes

Output Schema

NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed4 schema fields changedv3.0.0
    • addedInput schema / properties / database / description
      Added value: +"Quote names that aren't all uppercase, exactly as list tools return them."
    • addedInput schema / properties / schema_name / description
      Added value: +"Quote names that aren't all uppercase, exactly as list tools return them."
    • addedInput schema / properties / task_name / description
      Added value: +"Quote names that aren't all uppercase, exactly as list tools return them."
    • addedInput schema / properties / warehouse / description
      Added value: +"Quote names that aren't all uppercase, exactly as list tools return them."
  2. Addedv2.0.4

TDQS

C2.9/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint=false, destructiveHint=false, idempotentHint=false and openWorldHint=true, so the safety profile is covered. The description adds the genuinely useful 'scheduled or serverless' distinction, which hints that a task may run without a warehouse, but it omits what if_not_exists=true (the default) actually does on collision and says nothing about permissions.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

One short, front-loaded sentence with no filler. Its brevity is efficient rather than padded, though the same terseness leaves the gaps noted elsewhere.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a 7-parameter creation tool, the description omits the scheduled-vs-serverless warehouse rule, the meaning of the defaulted if_not_exists, required privileges, and any note on what the output schema returns. Output schema coverage helps, but the behavioral and parameter story is materially incomplete.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 57%; four name-ish params carry only a repeated quoting hint, while schedule, sql_statement and if_not_exists have no schema description at all. The description contributes zero parameter meaning, so it does not compensate for the gap on the three most consequential fields (cron syntax, task body, collision behavior).

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb (Create) and resource (task) with a meaningful qualifier: 'scheduled or serverless' distinguishes the two Snowflake task modes. It is clearly separable from siblings like tasks_drop_task, tasks_execute_task, tasks_suspend_task and tasks_describe_task by verb alone, though it never names an alternative.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No when-to-use guidance, no prerequisites (CREATE TASK privilege, EXECUTE TASK on the warehouse), and no statement about how it relates to tasks_resume_task or tasks_execute_task. The agent must infer everything from the single verb.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools