Query with confidence

Hex integrates with dbt to pull metadata on freshness and tests right into the flexible notebook environment where you're writing queries.

How it works

When Hex has been connected to a dbt Cloud project, metadata on source freshness and tests will be surfaced directly in the schema browser. This lets users write queries with full confidence that the data they're returning is up to date and accurate, rather than just taking it on faith.

Bringing this metadata right into the data notebook where actual analytical work is happening gives data analysts and scientists the ability to move fast and be flexible, while knowing they aren't inadvertently accessing stale or inaccurate data.

Stay tuned for more exciting integrations with dbt!

snowflake
Snowflake DB
in-use
2 cells
vehicle_destinations16 cols, 192 rows
dbt
Model
2 min ago
green-tick
Tests
VEHICLE_ID
string
MODEL
string
SPEED
number
BUILD_DATE
datetime
snowflake
Snowflake DB
Browse schema
select
cast (month as timestamp) as month,
ship,
destination,
sum(spice_tons) as spice_tons
from atreides.vehicle_destinations
group by 1,2,3
Chart
Table