Build interactive data applications with PostgreSQL data

Hex securely and efficiently connects to Postgres to let you build rich analyses and data apps with SQL.

How it works

Once a Hex admin has connected to a PostgreSQL database, it's easy for any user to securely query data with a rich SQL IDE— right from the notebook environment.

Hex is a powerful data platform with first-class SQL support, so you can build powerful analyses and data apps entirely from SQL— or bring in Python and leverage its rich package library, without changing tools or moving data.

Get started

Read the docs

Postgres

2 cells

Atriedes, Inc.

Last updated: 3 min ago

Postgres

select

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

ship, destination,

sum(spice_tons) as spice_tons

from atreides.vehicle_destinations