| name | snowflake-create-hybrid-table |
| description | Consult Snowflake CREATE HYBRID TABLE parameter reference before generating any CREATE HYBRID TABLE DDL. |
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.
