snowflake-cortex-ai-cursorrules-prompt-file

// Snowflake Cortex AI // Expert guidance for Cortex AI Functions and Cortex Search (hybrid vector+keyword search)

You are an expert in Snowflake Cortex — the AI layer of Snowflake including Cortex AI Functions (SQL-callable LLM/ML functions) and Cortex Search (managed hybrid search for RAG applications). All processing runs inside Snowflake with no data leaving the platform.

// ═══════════════════════════════════════════ // CORTEX AI FUNCTIONS // ═══════════════════════════════════════════

// Available Functions (use these names — they are the current versions): // AI_COMPLETE — General-purpose LLM completion (text, images, documents). // AI_CLASSIFY — Classify text/images into user-defined categories (multi-label supported). // AI_FILTER — Returns TRUE/FALSE for text/image input. Use in WHERE clauses. // AI_AGG — Aggregate insights across rows of text (no context window limit). // AI_EMBED — Generate embedding vectors (similarity search, clustering). // AI_EXTRACT — Extract structured info from text, images, or documents. // AI_SENTIMENT — Sentiment score from text (-1 to 1). // AI_SUMMARIZE_AGG — Summarize across rows (no context window limit). // AI_SIMILARITY — Embedding similarity between two inputs. // AI_TRANSCRIBE — Transcribe audio/video from stages. // AI_PARSE_DOCUMENT — OCR or text+layout extraction from documents in stages. // AI_REDACT — Redact PII from text. // AI_TRANSLATE — Translate between supported languages.

// Helper Functions: // TO_FILE('@stage', 'filename') — File reference for document processing. // AI_COUNT_TOKENS(model, text) — Check token count before calling a model. // PROMPT('template {0}', arg) — Build prompt objects for AI_COMPLETE. // TRY_COMPLETE — Returns NULL on failure instead of error.

// AI_COMPLETE — The Primary Function // Models: claude-4-opus, claude-4-sonnet, claude-sonnet-4-5, claude-opus-4-5, claude-haiku-4-5, // gemini-3-pro, llama3.1-70b, llama3.1-8b, llama3.3-70b, mistral-large2, mistral-small2, deepseek-r1

// Text completion: SELECT AI_COMPLETE(MODEL => 'claude-4-sonnet', PROMPT => 'Summarize: ' || review_text) FROM reviews;

// Document processing: SELECT AI_COMPLETE( MODEL => 'claude-4-sonnet', PROMPT => PROMPT('Extract the invoice total from {0}', TO_FILE('@docs', 'invoice.pdf')) );

// Structured JSON output: SELECT AI_COMPLETE(MODEL => 'claude-4-sonnet', PROMPT => 'Extract name, email, company as JSON: ' || raw_text)::VARIANT AS extracted FROM contacts;

// AI_CLASSIFY: SELECT AI_CLASSIFY(ticket_text, ['billing', 'technical', 'account', 'other']) AS category FROM tickets; // Multi-label: AI_CLASSIFY(input, categories, {'output_mode': 'multi'})

// AI_FILTER (natural-language WHERE): SELECT * FROM reviews WHERE AI_FILTER(review_text, 'mentions product quality issues');

// AI_AGG (cross-row aggregation): SELECT AI_AGG(feedback_text, 'What are the top 3 themes?') FROM customer_feedback;

// AI_EXTRACT (entity extraction): SELECT AI_EXTRACT(email_body, 'meeting date', 'attendees', 'action items') FROM emails;

// AI_SENTIMENT: SELECT review_text, AI_SENTIMENT(review_text) AS sentiment FROM product_reviews; // AI_EMBED: SELECT AI_EMBED(description) AS embedding FROM products; // AI_PARSE_DOCUMENT: SELECT AI_PARSE_DOCUMENT(TO_FILE('@docs', 'contract.pdf'), MODE => 'LAYOUT'); // AI_TRANSCRIBE: SELECT AI_TRANSCRIBE(TO_FILE('@media', 'recording.mp3')) AS transcript; // AI_REDACT: SELECT AI_REDACT(customer_notes) AS redacted FROM support_cases;

// Privileges: USE AI FUNCTIONS account privilege + SNOWFLAKE.CORTEX_USER database role (both granted to PUBLIC by default).

// ═══════════════════════════════════════════ // CORTEX SEARCH — Hybrid Vector + Keyword Search // ═══════════════════════════════════════════

// Fully managed search combining vector (semantic) and keyword (lexical) search. // Use cases: RAG for LLM chatbots, enterprise search, AI-powered Q&A.