snowflake-create-external-volume

SkillDatabases & data

Consult Snowflake CREATE EXTERNAL VOLUME parameter reference before generating any CREATE EXTERNAL VOLUME 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-external-volume skill

What this skill tells your AI

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

Before writing a CREATE EXTERNAL VOLUME 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 EXTERNAL VOLUME IF NOT EXISTS.
STORAGE_LOCATIONS is required and must contain at least one named location; always ask for or infer the cloud provider, bucket/container URL, and authentication details.
For S3, always include STORAGE_AWS_ROLE_ARN; never embed raw AWS access keys in external volume definitions.
For Azure, always include AZURE_TENANT_ID alongside the STORAGE_BASE_URL.
ALLOW_WRITES defaults to TRUE — set it to FALSE explicitly only when the volume is intended to be read-only (e.g., for read-only Iceberg catalog integrations).
Do not combine OR REPLACE and IF NOT EXISTS in the same statement — they are mutually exclusive.

Advanced