Agent Interface
SQL REST APISnowpark (Python/Java/Scala)Snowflake Cortex (AI)MCP Server (community)
What an agent can do
- ✓Execute SQL queries and retrieve results via REST
- ✓Manage databases, schemas, tables, and views
- ✓Create and manage data pipelines (Snowpipe, Tasks, Streams)
- ✓Access Cortex AI functions (LLM, embeddings, classification)
- ✓Share data across accounts with Snowflake Data Sharing
- ✓Manage warehouses (compute) programmatically
What it can't do
- ✗Access raw storage layer or bypass query engine
- ✗Modify account billing or credit usage limits via API
- ✗Stream query results in real-time (polling only)
- ✗Access Snowflake Marketplace listings configuration via API
- ✗Modify network policies or private connectivity settings via REST
Auth Model
Key Pair AuthenticationOAuth 2.0 (external or Snowflake-managed)Username/Password (Basic Auth)
Builder Notes
SQL REST API enables data-access agents. Cortex AI brings LLM functions directly into SQL queries. Snowpark enables running Python/Java/Scala code within Snowflake compute. Particularly relevant for data pipeline and analytics agents. Credit-based compute billing.
Sources
Last verified: 2026-03-15