Menu
Consult Snowflake CREATE PIPE parameter reference before generating any CREATE PIPE DDL.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
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-pipe |
| description | Consult Snowflake CREATE PIPE parameter reference before generating any CREATE PIPE DDL. |
Before writing a CREATE PIPE statement:
references/parameters.md to review all available parameters and their defaults.CREATE OR REPLACE — always use CREATE PIPE IF NOT EXISTS.AS <copy_statement> clause is required; always generate a valid COPY INTO <table> FROM @<stage> statement as part of the pipe definition.AUTO_INGEST = TRUE is required for fully automated Snowpipe ingestion from external stages; it requires cloud event notification setup (SQS for S3, Pub/Sub for GCS, Azure Event Grid for Azure).AWS_SNS_TOPIC with the ARN of the SNS topic configured on the source bucket.INTEGRATION referencing a notification integration.ERROR_INTEGRATION is optional but recommended for production pipelines to route load errors to a notification channel.OR REPLACE and IF NOT EXISTS in the same statement — they are mutually exclusive.