cortex-code

name	cortex-code
description	Routes Snowflake-related operations to Cortex Code agent for specialized Snowflake expertise. Use when querying databases, checking data quality, or asking about Snowflake features.
license	Proprietary. See LICENSE for complete terms

Cortex Code Integration

Routes Snowflake queries to Cortex Code agent with conversation context enrichment.

When to Use

Use this skill when the user asks about:

• Snowflake databases, warehouses, schemas, tables, views
• SQL queries for Snowflake data ("How many databases?", "Show top customers")
• Data quality checks, validation, profiling
• Cortex AI features (Cortex Search, Cortex Analyst, ML functions)
• Semantic views, data modeling
• Snowpark, dynamic tables, streams, tasks
• Snowflake security, roles, policies, governance

Instructions

Step 1: Build Enriched Context

Before executing, build an enriched prompt that includes:

1. Conversation Context (if relevant):

   • Previous 2-3 exchanges from this conversation
   • Any Snowflake-specific details already discussed
   • User's stated goals or requirements

2. User's Question:

   • The current query being asked

Step 2: Execute with Context

Pass the enriched context to Cortex Code:

python3 scripts/execute_cortex.py \
  --prompt "# Conversation Context
[relevant prior exchanges if any]

# Current Question
[USER'S QUESTION]" \
  --envelope "RO"

Example with Context

If user previously asked "Which databases have stock data?" and now asks "Show me the schema for the main table":

python3 scripts/execute_cortex.py \
  --prompt "# Recent Context
User previously identified databases with stock data: DB_STOCK, FINANCE__ECONOMICS

# Current Question
Show me the schema for the main table in DB_STOCK" \
  --envelope "RO"

Example without Context

For standalone questions:

python3 scripts/execute_cortex.py \
  --prompt "How many databases do I have in Snowflake?" \
  --envelope "RO"

How It Works

1. Agent builds enriched prompt with conversation context
2. Routes to Cortex Code agent (headless execution)
3. Cortex executes cortex CLI with stream-json format
4. Runs SQL queries via snowflake_sql_execute tool
5. Returns formatted results with analysis

Configuration

• Approval mode: prompt by default; request user approval before execution
• Security envelope: RO for reads; RW only for approved writes
• Connection: Uses default Snowflake connection from cortex CLI