snowflake-create-dynamic-table

SkillDatabases & data

Consult Snowflake CREATE DYNAMIC TABLE parameter reference before generating any CREATE DYNAMIC TABLE 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-dynamic-table skill

What this skill tells your AI

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

Before writing a CREATE DYNAMIC TABLE 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 DYNAMIC TABLE IF NOT EXISTS where supported.
Always specify both TARGET_LAG and WAREHOUSE — they are required. Choose TARGET_LAG = DOWNSTREAM only when the dynamic table feeds other dynamic tables and downstream refresh semantics are desired; otherwise use an explicit interval (e.g., '1 minutes').
Prefer REFRESH_MODE = AUTO unless the user explicitly requires FULL or INCREMENTAL; the system will choose the most efficient mode automatically.
Do not add CLUSTER BY unless the table is expected to be multi-terabyte or the user requests it.
Do not use EXECUTE AS USER unless the user explicitly provides an impersonation user, as it requires the IMPERSONATE privilege.
Append the defining query as the AS <query> clause at the end of the statement — it is required.

Advanced