version: "1.0.0" name: snowflake-create-connection description: Consult Snowflake CREATE CONNECTION parameter reference before generating any CREATE CONNECTION DDL.
Before writing a CREATE CONNECTION 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 CONNECTION IF NOT EXISTS. - Use the primary connection syntax when creating a new connection; use the secondary syntax (
AS REPLICA OF) when creating a secondary connection to replicate an existing primary. - For secondary connections, the name must match the primary connection's name exactly.
- Connection names must be unique across all connection and account names in the organization — verify this constraint.
- Only ACCOUNTADMIN can execute CREATE CONNECTION — note this privilege requirement.