​
Overview

The Snowflake integration enables your agents to query and analyze data in your Snowflake data warehouse. Perfect for business intelligence, data analysis, and generating insights from your enterprise data while maintaining Snowflake’s security and performance standards.

​
Features

  • Enterprise SQL Queries: Execute any SQL query on your Snowflake warehouse
  • Automatic Scaling: Warehouses scale based on query complexity
  • Cost Optimization: Automatic warehouse suspension to control costs
  • Clean Results: Structured, easy-to-read query results
  • Advanced Analytics: Support for complex analytical queries and functions
  • Secure Access: Enterprise-grade security and access controls

​
Prerequisites

  • Active Snowflake account with data warehouse access
  • User credentials with query permissions on target databases
  • Warehouse name with sufficient compute resources
  • Database and schema access rights for your data
  • Network connectivity to Snowflake servers

​
Setup Guide

1

Enable Snowflake Integration

Navigate to Control Hub > Integrations and locate the Snowflake card. Click “Connect” to begin setup.

2

Configure Connection

Provide your Snowflake connection details:

  • Account: Your account identifier (e.g., abc123.us-east-1, excluding .snowflakecomputing.com)
  • User: Your Snowflake username
  • Password: Your account password
  • Warehouse: Name of the warehouse to use for queries
  • Database: (Optional) Default database to connect to
  • Schema: (Optional) Default schema within the database
  • Role: (Optional) Role to assume for queries
3

Test Connection

Click “Test Connection” to verify your configuration. The system will attempt to connect and run a simple test query.

​
Security Considerations

  • Use read-only accounts when possible to limit data modification
  • Enable IP allowlisting in Snowflake for additional security
  • Implement role-based access to control what data agents can access
  • Set warehouse size limits to control compute costs
  • Rotate credentials regularly and use strong passwords
  • Monitor query history for unusual or unauthorized activity
  • Use separate roles for different agent purposes

​
Troubleshooting

  • Snowflake SQL - Execute SQL queries on your Snowflake warehouse