snowflake-create-failover-group

SkillDatabases & data

Consult Snowflake CREATE FAILOVER GROUP parameter reference before generating any CREATE FAILOVER GROUP 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-failover-group skill

What this skill tells your AI

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

Before writing a CREATE FAILOVER GROUP 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 FAILOVER GROUP IF NOT EXISTS.
Use the primary group syntax when creating in the source account; use the secondary (AS REPLICA OF) syntax when creating in a target account.
OBJECT_TYPES is required — always confirm which object types the user wants to replicate.
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.
ALLOWED_ACCOUNTS is required and must use org_name.account_name format.
This feature requires Business Critical Edition or higher — note this limitation when relevant.

Advanced