snowflake-create-aggregation-policy

分类: 工具与效率 | 上传者: Gyrus-Dev | 下载: 0 | 版本: v1.0（最新）

在生成任何 CREATE AGGREGATION POLICY DDL 之前，请查阅 Snowflake CREATE AGGREGATION POLICY 参数参考。

更新日志: Source: GitHub https://github.com/Gyrus-Dev/frosty

目录结构

当前层级: tree/main/skills/snowflake-create-aggregation-policy/

📁 references/
- 📄 parameters.md 2.4 KB
📄 SKILL.md 1.0 KB

SKILL.md

---
name: snowflake-create-aggregation-policy
description: Consult Snowflake CREATE AGGREGATION POLICY parameter reference before generating any CREATE AGGREGATION POLICY DDL.
---

Before writing a CREATE AGGREGATION POLICY statement:
1. Read `references/parameters.md` to review all available parameters and their defaults.
2. For each parameter, decide whether the user's request implies a non-default value.
3. Include only the parameters that differ from the default or that the user explicitly requested.
4. Never use `CREATE OR REPLACE` — always use `CREATE AGGREGATION POLICY IF NOT EXISTS`.
5. The policy body must call either `NO_AGGREGATION_CONSTRAINT()` (unrestricted access) or `AGGREGATION_CONSTRAINT(MIN_GROUP_SIZE => <n>)` (requires aggregation with at least n rows per group).
6. Aggregation policies require Snowflake Enterprise Edition or higher; warn the user if their account edition is unknown.
7. The policy body cannot reference user-defined functions, tables, or views — only the built-in constraint functions are allowed.

登录后下载/点赞/收藏 ❤ 38 | ★ 0

snowflake-create-aggregation-policy

目录结构

SKILL.md

举报内容

提示