ClickHouse Connector
Connect to ClickHouse for analytics queries over large datasets.
Overview
The ClickHouse connector supports:
- Native and HTTP protocols
- Analytics workloads
- Natural language queries
- Schema discovery
Prerequisites
- ClickHouse server access
- User credentials
- Network connectivity
Configuration
| Setting | Description |
|---|---|
| Host | ClickHouse hostname |
| Port | Native (9000) or HTTP (8123) |
| Database | Database name |
| Username | DB user |
| Password | User password |
| Protocol | Native or HTTP |
Setup Steps
- Add Connector: Knowledge → Add Data Source → ClickHouse
- Enter Connection: Host, port, database
- Select Protocol: Native or HTTP
- Provide Credentials: Username and password
- Test & Create: Verify and save
Best Practices
- Use native protocol for performance
- Create read-only user
- Index commonly queried columns
- Consider query timeouts for large tables
Troubleshooting
Connection failed: Check port and protocol
Timeout: Large queries may need timeout adjustment
Memory error: Query may need optimization