ClickHouse

​

Prerequisites

• A ClickHouse server or cloud instance
• User credentials with appropriate access
• Server host and port information
• SSL certificates (if using secure connection)

​

Connection setup

1. From your Basedash dashboard, click “Add Data Source”
2. Select “ClickHouse” as your data warehouse
3. Enter your connection details:
   • Host
   • Port (default: 8123 for HTTP, 9440 for HTTPS)
   • Database name
   • Username
   • Password
   • SSL settings (if required)
4. Click “Test Connection” to verify
5. Save your connection

​

Required permissions

• SELECT privilege on required databases/tables
• SHOW privilege on databases
• SHOW TABLES privilege
• SHOW COLUMNS privilege

​

Best practices

• Create a dedicated user for Basedash
• Enable SSL for secure connections
• Grant minimum required permissions
• Set appropriate query limits
• Regularly rotate credentials

​

Performance optimization

• Use appropriate table engines
• Configure proper partitioning
• Set up materialized views
• Monitor query performance
• Use efficient indexing
• Enable query caching

​

Troubleshooting

• Verify user permissions
• Check server connectivity
• Monitor resource usage
• Review server logs
• Validate query syntax
• Check SSL configuration

​

Next steps: Add custom context

​

When to add context

• Complex analytics data: When the AI needs help understanding data structure and metrics
• Business-specific metrics: If calculated fields or KPIs need additional explanation
• Unclear naming conventions: When table or column names don’t clearly indicate their purpose