Hex
Hex is a collaborative data workspace that combines SQL, Python, R, and no-code tools in a single platform. It enables data teams to explore, analyze, and share insights through interactive notebooks and dashboards.
Connection Setup
Hex connects to Altertable using our Postgres adapter, which works with Hex's built-in PostgreSQL database support.
Configuration Steps
- In Hex, navigate to Data → Warehouse → Add data connection
- Select Postgres as the connection type
- Configure the connection with the following details:
Field | Value |
|---|---|
Display name | Altertable (or your preferred name) |
Host | postgres.altertable.ai |
Port | 443 |
Database | Your Altertable catalog name |
Username | Your lakehouse username |
Password | Your lakehouse password |
SSL/TLS | ✓ Required |
- Click Save to save the connection
Notes
- SQL Dialect: While the connection uses the Postgres protocol, queries are executed using DuckDB SQL dialect. PostgreSQL-specific functions may not be available.
- SSL/TLS Required: Make sure SSL/TLS is enabled in the connection settings
- Catalog Name: Enter your Altertable catalog name in the Database field