KUNDUL Let's talk

Snowflake Intelligence: A Beginner's Guide

Ask questions in plain English and get answers from your data—no SQL required.

What is Snowflake Intelligence?

Snowflake Intelligence is an AI assistant that lives inside Snowflake. Think of it as a colleague who knows your data and can answer complex questions in natural language. Instead of writing SQL or building reports yourself, you ask things like “Why did sales of Fitness Wear grow so much in July?” or “What issues are people reporting with jackets in support tickets?” and get clear, data-backed answers.

It goes beyond just showing numbers (“what” happened) and helps explain the “why”—so you can make better decisions faster. It’s built for enterprises, so it respects your existing security and governance while scaling with your data.

Why Does It Matter?

  • Trust and traceability: You can trace every answer back to its source and define “golden” questions that always get verified, consistent answers.
  • One place for data: It can reason across structured data (tables, numbers) and unstructured data (support tickets, documents) in one place.
  • Self-service: More people can explore data and get insights without waiting on a data team.

Who Uses It? (Use Cases)

Sales and performance

Managers ask things like “What were my top product sales in the West last quarter, and why did product X outperform Y?” Analysts can dig into trends like “Why are support tickets going up?” by combining different data sources.

Research and financial insights

Teams combine internal data with external sources (e.g. market news, industry reports) to get richer context—for example, portfolio performance plus news, or customer feedback plus market trends.

Self-service exploration

Any business user can explore data and get answers to complex questions without depending on data teams, so decisions happen faster.

How It Works: The Main Pieces

Snowflake Intelligence is built around agents—AI assistants configured with specific “tools” and instructions. When you ask a question, the agent chooses the right tool and returns an answer. Two core tools are:

Cortex Analyst

Used for structured data (tables in Snowflake). The agent uses “semantic models”—mappings between business terms (e.g. “product name,” “sales”) and your actual tables and columns—to generate and run SQL for you. So even if your table names are technical, the AI still understands how to query them.

Cortex Search

Used for unstructured text—support tickets, Slack threads, contracts, etc. Your text is indexed and searchable; the agent uses this (a form of “retrieval augmented generation,” or RAG) to find relevant passages and answer questions from documents and conversations.

You can also add custom tools (e.g. “send an email”) so the agent can both answer questions and take actions—like emailing a summary to the right people.

Getting Started (High-Level)

You’ll need a Snowflake account with the right role and a region that supports Snowflake Intelligence. Then, in broad steps:

  1. Set up data: Create a database/schema, load your data (e.g. from S3), and run the setup scripts (Snowflake provides a sample repo for this).
  2. Configure Cortex Analyst: Upload a semantic model (YAML) that describes your business concepts and how they map to tables and columns. This is what lets the AI “understand” your data.
  3. Configure Cortex Search (optional): Point it at tables with text (e.g. support cases), pick the columns to search and to display (e.g. title, product, transcript), and create a search service.
  4. Create an agent: Give it a name, add instructions and example questions, then attach the tools (Cortex Analyst with your semantic model, Cortex Search services, and any custom tools like email).
  5. Use Snowflake Intelligence: Open the Snowflake Intelligence UI, select your agent, and start asking questions. You can ask for trends, reasons, support insights, and even “send a summary email.”

Snowflake’s official guide walks through a concrete example (e.g. “Sales//AI” agent with marketing and support data) so you can try real questions like “Show me the trend of sales by product category between June and August” or “What issues are reported with jackets recently?”

Bottom Line

Snowflake Intelligence turns your Snowflake account into a place where anyone can ask complex questions in natural language and get trusted, traceable answers—combining structured and unstructured data, with optional actions like sending emails. Once you’ve set up an agent with the right tools and semantic model, you’re ready to explore your data without writing SQL.

Need help with Snowflake Intelligence?

Kundul helps teams deliver Snowflake data engineering, dbt development, Fivetran integration, and Snowflake Intelligence solutions.

Book a call

Learn More