Run fast & interactive queries directly on your data lake

Hex easily connects with Dremio to power data workflows and analysis right on data in the lakehouse.

How it works

It only takes a couple clicks to set up a connection between Hex and a Dremio Cloud lakehouse. Once that's done, every user of the Hex workspace can securely query data from the lakehouse right into a flexible data notebook.

Hex has first class SQL support, so you can build beautiful charts, powerful analyses, and interactive data apps entirely from SQL— or you can switch over to Python and leverage its rich package library.

dremio Dremio
in-use2 cells
dremio Dremio
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