<< All versions
Skill v1.0.0
currentAutomated scan100/100gyrus-dev/frosty/snowflake-create-internal-stage
──Details
PublishedNovember 3, 2026 at 09:01 PM
Content Hashsha256:bb4f53b12f658a19...
Git SHAf282c180b8ca
──Files
Files (1 file, 1.4 KB)
SKILL.md1.4 KBactive
SKILL.md · 17 lines · 1.4 KB
name: snowflake-create-internal-stage description: Consult Snowflake CREATE STAGE parameter reference before generating any CREATE STAGE DDL for internal stages. metadata: version: "1.0.0"
Before writing a CREATE STAGE statement for an internal 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. - Named internal stages are the correct choice for sharing data across multiple tables or users within an account; use user stages (@~) or table stages (@%table) only when the user explicitly requests them (they cannot be created with DDL).
- The default encryption for internal named stages is
SNOWFLAKE_FULL(client-side + server-side). UseSNOWFLAKE_SSEonly when the user explicitly wants server-side-only encryption. - Attach a FILE_FORMAT only when the user specifies a non-CSV format or custom format options; omit otherwise to rely on COPY INTO defaults.
- Enable the DIRECTORY table (
DIRECTORY = ( ENABLE = TRUE )) only when the user needs to browse or query staged files via directory table functions.