snowflake-create-aggregation-policy
SkillDatabases & dataConsult Snowflake CREATE AGGREGATION POLICY parameter reference before generating any CREATE AGGREGATION POLICY 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-aggregation-policy skill
What this skill tells your AI
The instructions your AI receives, as published by gyrus-dev/frosty in skills/snowflake-create-aggregation-policy/SKILL.md and read by ahel’s review.
Before writing a CREATE AGGREGATION POLICY statement:
- Read
references/parameters.mdto 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 useCREATE AGGREGATION POLICY IF NOT EXISTS. - The policy body must call either
NO_AGGREGATION_CONSTRAINT()(unrestricted access) orAGGREGATION_CONSTRAINT(MIN_GROUP_SIZE => <n>)(requires aggregation with at least n rows per group). - Aggregation policies require Snowflake Enterprise Edition or higher; warn the user if their account edition is unknown.
- The policy body cannot reference user-defined functions, tables, or views — only the built-in constraint functions are allowed.
Signals
- GitHub stars
- 77
- Forks
- 9
- Last commit
- Apr 2026
Advanced
- Catalog kind
- skill
- Gateway key
snowflake-create-aggregation-policy- Source
- github.com/gyrus-dev/frosty