snowflake-create-cortex-search

SkillSearch

Consult Snowflake CREATE CORTEX SEARCH SERVICE parameter reference before generating any CREATE CORTEX SEARCH SERVICE 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-cortex-search skill

What this skill tells your AI

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

Before writing a CREATE CORTEX SEARCH SERVICE 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 CORTEX SEARCH SERVICE IF NOT EXISTS where supported.
Choose between single-index syntax (ON <search_column>) and multi-index syntax (TEXT INDEXES ... VECTOR INDEXES ...) based on the user's retrieval requirements; use multi-index when both keyword and vector similarity search are needed.
Always specify WAREHOUSE and TARGET_LAG; they are required.
Supply a PRIMARY KEY whenever the source table has a natural unique key — it enables optimized incremental refresh.
Default REFRESH_MODE is INCREMENTAL; only override to FULL when the source table lacks change-tracking support.

Advanced