
from frosty59
Guidance for authoring Snowflake CREATE REPLICATION GROUP DDL: validate parameters, avoid CREATE OR REPLACE, include only non-default or requested clauses, and
This skill provides prescriptive, parameter-aware guidance for generating Snowflake CREATE REPLICATION GROUP statements. It directs an agent to consult the parameter reference, decide when non-default values are required, and produce minimal, correct DDL using CREATE REPLICATION GROUP IF NOT EXISTS semantics. The skill emphasizes required fields (OBJECT_TYPES, ALLOWED_ACCOUNTS) and correct patterns for primary vs. replica group creation.
Use this skill when a user asks the agent to create or scaffold Snowflake replication group DDL, or when converting high-level replication requirements into concrete SQL statements. It's intended for cases where correctness and least-surprise behavior matter (avoid unnecessary clauses and do not use CREATE OR REPLACE).
references/parameters.md which lists all configurable parameters and defaults; the agent must consult this before emitting DDL.Best used by SQL-capable coding assistants and agents with Snowflake knowledge (Copilot-style code helpers, SQL LLM prompts, or internal DB automation tools).
This skill has not been reviewed by our automated audit pipeline yet.