<< All versions
Skill v1.0.0
currentAutomated scan100/100gyrus-dev/frosty/snowflake-create-failover-group
──Details
PublishedNovember 3, 2026 at 05:01 PM
Content Hashsha256:1b73ed5e8b0a0988...
Git SHAf282c180b8ca
──Files
Files (1 file, 1.3 KB)
SKILL.md1.3 KBactive
SKILL.md · 18 lines · 1.3 KB
name: snowflake-create-failover-group description: Consult Snowflake CREATE FAILOVER GROUP parameter reference before generating any CREATE FAILOVER GROUP DDL. metadata: version: "1.0.0"
Before writing a CREATE FAILOVER GROUP 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 — do not bloat the DDL with unnecessary clauses.
- Never use
CREATE OR REPLACE— always useCREATE 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_TYPESis required — always confirm which object types the user wants to replicate.- When DATABASES is in OBJECT_TYPES,
ALLOWED_DATABASESis also required. Similarly,ALLOWED_SHARESis required when SHARES is included,ALLOWED_EXTERNAL_VOLUMESfor EXTERNAL VOLUMES, andALLOWED_INTEGRATION_TYPESfor INTEGRATIONS. ALLOWED_ACCOUNTSis required and must useorg_name.account_nameformat.- This feature requires Business Critical Edition or higher — note this limitation when relevant.