Managed ClickHouse

Give event data a place of its own.

Collect product events, logs and reporting data in a column-oriented SQL database. Aggregate the columns you need without making your transactional application database carry every analytical query.

Configure your database Connection guide

ClickHouse / a familiar starting point

SELECT toStartOfHour(timestamp) AS hour,
       count() AS events, uniq(user_id) AS users
FROM product_events
GROUP BY hour
ORDER BY hour DESC;

Working with ClickHouse

Choose it for the work
it does well.

Read the columns you need

Column-oriented storage suits aggregations over events, logs and other analytical datasets.

Read the official guide

Design around MergeTree

Choose ordering keys and partitioning for the way you query and retain your data.

Read the official guide

Precompute repeated work

Materialized views can move repeated transformations into the ingestion path.

Read the official guide

Where it fits.

Product analytics, operational logs and SQL reporting across large event datasets.

Before you choose

DBTurbine currently offers dedicated single-node ClickHouse deployments and full cloud backups. HA and point-in-time recovery are not included for this engine.

Your database.
The server work, covered.

The workspace brings connections, access and recovery together. Your application keeps its standard database client.

Connect with confidence

Find your endpoint, port, credentials and certificate together, with examples for standard clients.

Control who gets in

Set allowed IPs and give applications separate users. Review permissions before opening access.

Keep recovery separate

Full cloud backups provide restore points away from the live database server.

Give ClickHouse its own workspace.

Choose a published node type, region and storage. Review your monthly total before checkout.

See configurations