ClickHouse

Connect your ClickHouse data warehouse to Basedash to analyze and visualize your enterprise data.

​

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

Your ClickHouse user needs:

• 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