Agentic Service Discovery

Resources

S

Snowflake

by Snowflake Inc.

Connect an AI agent to Snowflake to run SQL queries, load data into Snowflake tables, and build analytics workflows

DatabasesPaidBasic authdatabasedata-warehousesqlanalyticscloudetl

How agents use Snowflake

  • Query business metrics and KPIs for automated report generation
  • Load data into Snowflake tables directly from an agent workflow — no separate ETL job needed
  • Run aggregation queries to detect trends or anomalies
  • Build data pipelines that transform and move data between schemas
  • Answer ad-hoc business questions by generating and running SQL

Agent actions

Execute QueryRun a SQL SELECT query and return results

Inputs: sql, bindings

Returns: rows, rowCount, columns

Execute StatementExecute a DML or DDL statement (INSERT, UPDATE, DELETE, CREATE, etc.)

Inputs: sql, bindings

Returns: rowsAffected, success, queryId

Load DataInsert multiple rows into a Snowflake table

Inputs: tableName, rows, onConflict

Returns: rowsLoaded, success

List TablesList tables in a database or schema

Inputs: schema, pattern

Returns: tables, count

Example workflows

1

Analytics pipeline

Agent queries Snowflake for KPIs and generates automated reports

2

Event ingestion

Agent loads processed events into Snowflake for downstream analysis

3

Connect an agent to load data into Snowflake

Agent receives rows from an API, form, or another tool, and loads them straight into a Snowflake table — no manual CSV exports or ETL setup required

About Snowflake

Vendor
Snowflake Inc.
Pricing Always review details with the vendor
PaidCompute: from $2/credit (Standard). Storage: $23/TB/month compressed. $400 free trial credits.
Authentication
Basic auth
Rate limit Always review details with the vendor
1000 requests / minute
Compatible nodes
AgentResourceInputOutput

Put Snowflake behind your AI agent

Set up Snowflake alongside your other tools in the planner — no code — so AI can act on it for your customers.

Open the planner

Related Databases tools

Snowflake AI Agent Integration | Fugentic