메뉴
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.