<< All versions
Skill v1.0.0
currentAutomated scan100/100gyrus-dev/frosty/snowflake-create-external-stage
──Details
PublishedOctober 17, 2026 at 01:04 PM
Content Hashsha256:7a88ff8e279fa136...
Git SHA
──Files
Files (1 file, 1.3 KB)
SKILL.md1.3 KBactive
SKILL.md · 17 lines · 1.3 KB
version: "1.0.0" name: snowflake-create-external-stage description: Consult Snowflake CREATE STAGE parameter reference before generating any CREATE STAGE DDL for external stages.
Before writing a CREATE STAGE statement for an external stage:
- 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 STAGE IF NOT EXISTS. - Always include the required
URLparameter for external stages pointing to the correct cloud storage path (s3://, gcs://, or azure://). - Prefer
STORAGE_INTEGRATIONover inlineCREDENTIALSfor authentication — it is more secure and avoids embedding secrets in DDL. - If the user provides raw credentials (AWS keys, SAS tokens), emit them but add a comment recommending migration to a storage integration.
- Choose the encryption type appropriate to the cloud provider (AWS_SSE_S3, AWS_SSE_KMS, GCS_SSE_KMS, AZURE_CSE, etc.) only if the user explicitly requests encryption configuration.
- Enable the DIRECTORY table only when the user needs to query staged files via directory table functions.