SN

snowflake-create-replication-group

Help for generating correct Snowflake replication group DDL statements.

Install

mkdir -p .claude/skills/snowflake-create-replication-group && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/11258" && unzip -o skill.zip -d .claude/skills/snowflake-create-replication-group && rm skill.zip

Installs to .claude/skills/snowflake-create-replication-group

Activation

This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.

Consult Snowflake CREATE REPLICATION GROUP parameter reference before generating any CREATE REPLICATION GROUP DDL.
114 charsno explicit “when” trigger
Intermediate

Key capabilities

  • Generates replication group DDL
  • Reviews replication parameters
  • Configures account replication settings

How it works

The tool provides a reference-based guide to generate correct Snowflake DDL for replication groups, ensuring parameters match user requirements.

Inputs & outputs

You give it
Replication group parameters
You get back
Snowflake DDL statement

When to use snowflake-create-replication-group

  • Generate replication group DDL
  • Review replication parameters
  • Configure account replication settings

About this skill

Before writing a CREATE REPLICATION GROUP 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 — do not bloat the DDL with unnecessary clauses.
  4. Never use CREATE OR REPLACE — always use CREATE REPLICATION GROUP IF NOT EXISTS.
  5. Use the primary group syntax when creating in the source account; use the secondary (AS REPLICA OF) syntax when creating in a target account.
  6. OBJECT_TYPES is required — always confirm which object types the user wants to replicate.
  7. When DATABASES is in OBJECT_TYPES, ALLOWED_DATABASES is also required. Similarly, ALLOWED_SHARES is required when SHARES is included, ALLOWED_EXTERNAL_VOLUMES for EXTERNAL VOLUMES, and ALLOWED_INTEGRATION_TYPES for INTEGRATIONS.
  8. ALLOWED_ACCOUNTS is required and must use org_name.account_name format.
  9. Unlike failover groups, replication groups do not support automatic failover — clarify this distinction if the user's intent is high availability.

When not to use it

  • Generating failover group DDL
  • Automating high availability failover

Limitations

  • Does not support automatic failover
  • Requires specific object type definitions

How it compares

It focuses specifically on replication group DDL generation, distinguishing it from failover group configuration.

Compared to similar skills

snowflake-create-replication-group side by side with the closest alternatives in the catalog.

SkillInstallsUpdatedSafetyDifficulty
snowflake-create-replication-group (this skill)04moNo flagsIntermediate
aws-aurora14moReviewIntermediate
k8s-storage16moNo flagsIntermediate
local-cluster-manager227dReviewIntermediate

Try saying

Example prompts that trigger this skill in your AI assistant.

Search skills

Search the agent skills registry