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
Connection Timeout
Connection Timeout
- Verify your account identifier format (should not include .snowflakecomputing.com)
- Check network connectivity to Snowflake
- Confirm the warehouse exists and is available
- Validate you’re using the correct account region
Authentication Failed
Authentication Failed
- Verify your username and password are correct
- Check that your user account is active
- Confirm role assignments and permissions
- Ensure your account hasn’t been suspended
Query Execution Error
Query Execution Error
- Verify the warehouse has sufficient compute resources
- Check that you have permissions on the tables/views
- Confirm access to the database and schema
- Review query syntax and complexity
Related Tools
- Snowflake SQL - Execute SQL queries on your Snowflake warehouse