Skip to content
Back to skills

Snowflake Create Cortex Search

ASecurity

Consult Snowflake CREATE CORTEX SEARCH SERVICE parameter reference before generating any CREATE CORTEX SEARCH SERVICE DDL.

  • 77 stars
  • 0 votes
  • 0 copies
  • 2 views
  • Added June 11, 2026
ai-agents

Security analysis

A100/100

Pro scans all 2 files and shows the line behind each finding

Scanned June 11, 2026

npx -y skills add Gyrus-Dev/frosty --skill snowflake-create-cortex-search --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Snowflake Create Cortex Search?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Snowflake Create Cortex Search
[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/gyrus-dev-snowflake-create-cortex-search/badge)](https://www.skillsdirectory.com/skills/gyrus-dev-snowflake-create-cortex-search)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro
SKILL.md
---
name: snowflake-create-cortex-search
description: Consult Snowflake CREATE CORTEX SEARCH SERVICE parameter reference before generating any CREATE CORTEX SEARCH SERVICE DDL.
---

Before writing a CREATE CORTEX SEARCH SERVICE statement:
1. Read `references/parameters.md` to review all available parameters and their defaults.
2. For each parameter, decide whether the user's request implies a non-default value.
3. Include only the parameters that differ from the default or that the user explicitly requested.
4. Never use `CREATE OR REPLACE` — always use `CREATE CORTEX SEARCH SERVICE IF NOT EXISTS` where supported.
5. 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.
6. Always specify `WAREHOUSE` and `TARGET_LAG`; they are required.
7. Supply a `PRIMARY KEY` whenever the source table has a natural unique key — it enables optimized incremental refresh.
8. Default `REFRESH_MODE` is INCREMENTAL; only override to FULL when the source table lacks change-tracking support.

Files in this skill

  • SKILL.md1.1 KB
  • references/parameters.md6.4 KB

Attribution

Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.

Comments

Loading comments…

Newsletter

Get the weekly list of safe new skills, and the ones we pulled.