Integrations
Snowflake
Connect your Snowflake data warehouse to your Agent
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