Access metrics layer definitions right from the notebook

Hex connects directly to Transform, so you can run all your reporting and exploration off of business metrics defined and blessed by the data team.

How it works

Configure a Hex connection to Transform just like any other SQL connection, and start writing metrics queries in a rich SQL IDEβ€” right from the same notebook environment where you'll do further data analysis and science.

Build powerful analyses and data apps entirely from SQL queries, knowing that all your business logic is rooted in a single source of truth.

Switch seamlessly over to Python when it's time for more complexity, without switching tools or losing data lineage from the metrics layer.

transform
Transform DB
in-use
2 cells
transform
Transform 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