Query data quickly from Clickhouse

Hex makes it easy to securely connect to your Clickhouse database, query, and bring your data to life in beautiful data apps.

How it works

Connecting a Clickhouse project to Hex means everyone can securely and efficiently query data right from the flexible notebook environment, without writing Python code or passing around credentials.

Hex features full SQL IDE functionality, with autocomplete, a schema browser, caching, and the ability to stream large results.

You can build and publish beautiful and interactive data apps entirely from SQL queries to your Clickhouse dataโ€” or you can switch seamlessly into Python and build models, enrich data, or merge other data sources.

clickhouse Clickhouse
in-use2 cells
clickhouse Clickhouse
select
cast({{timeframe}} as timestamp) as month,
ship, destination,
sum(spice_tons) as spice_tons
from atreides.vehicle_destinations
group by 1,2,3
output-arrow
dataframe