snowflake-create-hybrid-table

SkillDatabases & data

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

What this skill tells your AI

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

Before writing a CREATE HYBRID 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 HYBRID TABLE IF NOT EXISTS where supported.
A PRIMARY KEY constraint is mandatory — always include it. It may be defined inline on a single column or as an out-of-line constraint for composite keys.
PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints are enforced at the row level; do not set NOT ENFORCED on any constraint.
Do not apply COLLATE to primary key or indexed columns — collation is not supported on those columns.
Hybrid tables cannot be TEMPORARY or TRANSIENT; do not include those modifiers.
Hybrid tables are only available in AWS and Azure commercial regions; note this if the user's account region is relevant.
Use AUTOINCREMENT/IDENTITY with NOORDER for better point-write performance when the user needs a surrogate key.

Advanced