Database Connections

Connect to your enterprise databases with secure local caching for fast analysis. Privacy-focused with optimal performance.

Connect to your Snowflake data warehouse for enterprise-scale analysis with full feature support.

1. Go to Settings → Data Sources
2. Add Snowflake Connection with your account details
3. Test the Connection to verify credentials
4. Browse and Select tables to analyze
5. Start Analyzing with live data

Required Information

• Account Identifier: Your Snowflake account name
• Username: Your Snowflake username
• Password: Your Snowflake password (securely encrypted)
• Warehouse: Default warehouse for queries
• Database: Default database to connect to
• Schema: Default schema within the database

Optional Settings

• Role: Specific role for data access permissions
• Connection Timeout: Query timeout settings
• SSL Verification: Security settings for connection

Query Optimization

• Automatic query pushdown for better performance
• Intelligent sampling for large tables
• Parallel query execution when possible
• Automatic caching of frequently accessed data

Resource Management

• Configurable warehouse size recommendations
• Query cost estimation before execution
• Automatic query cancellation for runaway operations
• Connection pooling for multiple concurrent analyses

More database connectors are planned for future releases. Contact us if you need support for a specific database platform.

Account: your-company.snowflakecomputing.com
Username: your_username
Password: your_secure_password
Warehouse: COMPUTE_WH
Database: ANALYTICS_DB
Schema: PUBLIC
Role: ANALYST_ROLE

Local Processing

• All queries execute directly against your database
• No data is transmitted to external servers
• Results are processed entirely on your local machine
• Full compliance with data privacy regulations

Credential Security

• Passwords encrypted using industry-standard encryption
• Credentials stored only on your local machine
• Support for password-less authentication methods
• Integration with enterprise identity providers

Connection Security

• SSL/TLS encryption for all database connections
• Support for VPN and private network connections
• Firewall-friendly connection pooling
• Certificate-based authentication where supported

Access Control

• Database-level permissions respected
• Row-level security support
• Schema and table access controls
• Audit logging of database queries

Connection Timeouts

• Problem: Database connection times out
• Solution: Check firewall settings and network connectivity
• Alternative: Increase connection timeout in settings

Authentication Failures

• Problem: “Login failed” or authentication errors
• Solution: Verify username, password, and account details
• Alternative: Check user permissions and account status

Performance Issues

• Problem: Queries are slow or timing out
• Solution: Add database indexes for queried columns
• Alternative: Use data sampling for initial exploration

Network Access

• Problem: Cannot reach database server
• Solution: Configure firewall to allow database connections
• Alternative: Use VPN or database proxy if required

Database Optimization

• Index Strategy: Create indexes on frequently queried columns
• Query Optimization: Use database views to pre-filter large datasets
• Partitioning: Use table partitioning for very large datasets
• Statistics: Keep database statistics up to date

Network Optimization

• Connection Pooling: Use connection pooling for multiple queries
• Compression: Enable compression for large result sets
• Caching: Use database-level caching where possible
• Bandwidth: Consider network bandwidth for large datasets