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.
Why Connect Hex to Altertable?
Connecting Hex to Altertable enables you to:
- Unified Data Workspace: Access all your data sources connected to Altertable directly from Hex's collaborative notebooks
- Federated Queries: Query across multiple data sources (Postgres, MariaDB, Redshift, and more) without moving data
- High-Performance Analytics: Leverage Altertable's query engine for fast analytics on large datasets
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 Altertable username |
| Password | Your Altertable 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: Use your Altertable connection's catalog name as the database name