菜单
Consult Snowflake CREATE DYNAMIC TABLE parameter reference before generating any CREATE DYNAMIC 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-dynamic-table |
| description | Consult Snowflake CREATE DYNAMIC TABLE parameter reference before generating any CREATE DYNAMIC TABLE DDL. |
Before writing a CREATE DYNAMIC TABLE statement:
references/parameters.md to review all available parameters and their defaults.CREATE OR REPLACE — always use CREATE DYNAMIC TABLE IF NOT EXISTS where supported.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').REFRESH_MODE = AUTO unless the user explicitly requires FULL or INCREMENTAL; the system will choose the most efficient mode automatically.CLUSTER BY unless the table is expected to be multi-terabyte or the user requests it.EXECUTE AS USER unless the user explicitly provides an impersonation user, as it requires the IMPERSONATE privilege.AS <query> clause at the end of the statement — it is required.