菜单
Consult Snowflake CREATE EXTERNAL TABLE parameter reference before generating any CREATE EXTERNAL TABLE DDL.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Consult Snowflake CREATE AGGREGATION POLICY parameter reference before generating any CREATE AGGREGATION POLICY DDL.
Consult Snowflake CREATE ALERT parameter reference before generating any CREATE ALERT DDL.
Consult Snowflake CREATE API INTEGRATION parameter reference before generating any CREATE API INTEGRATION DDL.
Consult Snowflake CREATE APPLICATION PACKAGE parameter reference before generating any CREATE APPLICATION PACKAGE DDL.
Consult Snowflake CREATE AUTHENTICATION POLICY parameter reference before generating any CREATE AUTHENTICATION POLICY DDL.
Consult Snowflake CREATE COMPUTE POOL parameter reference before generating any CREATE COMPUTE POOL DDL.
| name | snowflake-create-external-table |
| description | Consult Snowflake CREATE EXTERNAL TABLE parameter reference before generating any CREATE EXTERNAL TABLE DDL. |
Before writing a CREATE EXTERNAL TABLE statement:
references/parameters.md to review all available parameters and their defaults.CREATE OR REPLACE — always use CREATE EXTERNAL TABLE IF NOT EXISTS where supported.LOCATION (referencing an external stage on S3, Azure, or GCS — internal Snowflake stages are not supported) and FILE_FORMAT.VALUE (VARIANT) pseudocolumn, METADATA$FILENAME, or METADATA$FILE_ROW_NUMBER; do not attempt to define plain physical columns.AUTO_REFRESH = TRUE and REFRESH_ON_CREATE = TRUE are the defaults; only override them if the user explicitly opts out of automatic refreshes.PARTITION_TYPE = USER_SPECIFIED only when the user intends to manage partitions manually via ALTER EXTERNAL TABLE … ADD PARTITION.