Postgres Adapter

The Postgres adapter enables you to connect to Altertable using the PostgreSQL wire protocol, providing compatibility with hundreds of business intelligence tools and database clients that don't natively support Arrow Flight SQL.

This adapter is ideal for:

• BI tools like Hex, Looker, Tableau, Power BI, and Metabase
• SQL clients such as DBeaver and pgAdmin

Authentication

Use your Altertable credentials with any Postgres-compatible client:

• Username: Your Altertable username
• Password: Your Altertable password

SQL Dialect

While the connection uses the Postgres protocol, queries are executed using DuckDB SQL dialect. This means that Postgres-specific functions (e.g., string_agg, generate_series) may not work.

Examples

psql

PGSSLMODE=require psql -h postgres.altertable.ai -p 443 -U your_username your_database

Python (psycopg2)

import psycopg2

conn = psycopg2.connect(
    host="postgres.altertable.ai",
    port=443,
    database="your_database",
    user="your_username",
    password="your_password"
)