ClickHouse
Overview
Send your ecommerce data to ClickHouse for blazing-fast columnar analytics, real-time aggregations, and efficient storage of large datasets.
Setup
- 1
Create a ClickHouse Cloud account or use an existing ClickHouse instance.
- 2
Note your host, port, database, and credentials.
- 3
Go to Dashboard > Outputs, click Connect on ClickHouse, and enter your connection details.
- 4
Data syncs automatically to your ClickHouse database.
Tips
- ClickHouse Cloud offers a free tier for getting started.
- Make sure your IP access list allows connections from our servers.
Fields Required
Host
your-clickhouse.cloud
Port
8443
Database
ecommerce
Username
default
Password
your_password
Setup Guide
- 1
Go to ClickHouse Cloud and sign in or create a free account.
https://clickhouse.cloud/ - 2
Click "New Service" to create a ClickHouse service (or use an existing one).
- 3
Open the service details — your Host is shown in the connection string.
- 4
Use port 8443 for HTTPS connections.
- 5
The default database is "default", or create a new one in the SQL console.
- 6
Username is "default" and the password was shown when the service was created.
Tips
- If you lost your password, go to Settings on your service and reset credentials.
- Make sure your ClickHouse IP access list allows connections from our servers.