Overview

The Snowflake integration enables your agents to directly interact with Snowflake data warehouses. This allows agents to query data, analyze results, and provide insights while maintaining Snowflake’s enterprise-grade security and performance features.

Features

  • SQL Query Execution: Run any SQL query on your Snowflake warehouse
  • Warehouse Management: Automatic warehouse suspension after queries complete
  • Result Formatting: Clean, structured table format for query results
  • Error Handling: Built-in error handling for common SQL issues
  • Type Safety: Automatic type conversion and validation

Prerequisites

  • Snowflake account with appropriate access
  • User credentials with query permissions
  • Warehouse name with compute resources
  • Database and schema access rights
  • Network access 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 (excluding snowflakecomputing.com)
  • User: Login name for the user
  • Password: User’s password
  • Warehouse: Name of the default warehouse
  • Database: (Optional) Default database name
  • Schema: (Optional) Default schema name
  • Role: (Optional) Default role to use
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
  • Enable IP allowlisting for additional security
  • Implement column-level access controls
  • Set appropriate warehouse size limits
  • Regularly rotate account credentials
  • Monitor query history for unauthorized access

Troubleshooting