snowflake-create-service

SkillDatabases & data

Consult Snowflake CREATE SERVICE parameter reference before generating any CREATE SERVICE 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-service skill

What this skill tells your AI

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

Before writing a CREATE SERVICE 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 — do not bloat the DDL with unnecessary clauses.
Never use CREATE OR REPLACE — always use CREATE SERVICE IF NOT EXISTS.
Always include IN COMPUTE POOL with the appropriate compute pool name.
Choose the correct specification variant: use FROM SPECIFICATION for inline or stage-referenced YAML specs, or FROM SPECIFICATION_TEMPLATE when the user provides template variables via USING.
Set AUTO_SUSPEND_SECS only when the user wants automatic suspension; the minimum effective value is 300 seconds (0 disables it).
Set MAX_INSTANCES explicitly when horizontal scaling beyond 1 instance is needed.
Include QUERY_WAREHOUSE only when service containers will run Snowflake queries.

Advanced