snowflake-create-stream

SkillDatabases & data

Consult Snowflake CREATE STREAM parameter reference before generating any CREATE STREAM DDL.

Available today. Use it from your connected AI after setup.

No other account needed.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the snowflake-create-stream skill

What this skill tells your AI

The instructions your AI receives, as published by gyrus-dev/frosty in skills/snowflake-create-stream/SKILL.md and read by ahel’s review.

Before writing a CREATE STREAM statement:

Read references/parameters.md to 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.
Never use CREATE OR REPLACE — always use CREATE STREAM IF NOT EXISTS where supported.
Choose the correct syntax variant based on the target object type: TABLE, EXTERNAL TABLE, STAGE (directory table), DYNAMIC TABLE, or VIEW.
For insert-heavy workloads on standard tables or views, recommend APPEND_ONLY = TRUE to improve performance.
For external tables, INSERT_ONLY = TRUE is required.
Streams on geospatial columns should use APPEND_ONLY = TRUE as standard streams cannot retrieve geospatial change data.
OR REPLACE and IF NOT EXISTS are mutually exclusive; never combine them.

Advanced