cortex-agents-with-custom-tools-tutorial

What problem does it solve?

This tutorial removes the complexity of building AI agents that must combine structured SQL analysis, semantic document retrieval, and custom business logic by teaching a repeatable, SQL-first workflow for creating multi-tool Cortex Agents that include stored-procedure tools.

Core Features & Use Cases

• End-to-end agent construction: Create semantic views for Cortex Analyst, index documents with Cortex Search, and register procedure-backed generic tools in a single CREATE AGENT specification.
• Custom business logic via procedures: Implement InventoryLookup, PriceCalculator, and ProductSummary as stored procedures callable by the agent with exact input_schema mappings.
• Testing and integration: Validate tools independently, parse DATA_AGENT_RUN JSON responses with Python, and use Snowflake Intelligence for interactive chat.
• Use Case: Build a 5-tool sales assistant that reports revenue, finds product docs, checks stock, computes bulk pricing, and summarizes product performance.

Quick Start

Tell the agent to build a sales assistant that uses Analyst for SQL, Search for docs, and three procedure-based custom tools.