Query data quickly from Clickhouse

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

How it works

Connecting ClickHouse to Hex means everyone can query real-time data directly through SQL, Python, or conversational AI agents.

Hex features a best-in-class notebook experience with SQL, Python, and an AI agent that can build entire projects on your behalf. Once built, turn these projects into beautiful dashboards and reports—all powered by ClickHouse.

Graduate beyond classic dashboards and build a conversational agent that sits directly on top of your ClickHouse data, understands and links to your existing apps, and is metadata aware for robust agentic reasoning. Experience the power of a data scientist at your fingertips.

Get started

Read the docs

Clickhouse

2 cells

Atriedes, Inc.

Last updated: 3 min ago

Clickhouse

select

cast({{timeframe}} as timestamp) as month,

ship, destination,

sum(spice_tons) as spice_tons

from atreides.vehicle_destinations