# Hex

[Hex](https://hex.tech/) 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](/docs/query-data/adapters/postgres.md), which works with Hex's built-in PostgreSQL database support.

### Configuration Steps

1. In Hex, navigate to **Data** → **Warehouse** → **Add data connection**
2. Select **Postgres** as the connection type
3. 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**                        |

5. 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