Skip to content
DocumentationLakehouse

Supabase

Add your Supabase database as an external catalog in Altertable to query and analyze it alongside your other data sources.

Before connecting, make sure Altertable can reach your source. Configure network access if it requires an IP allowlist or SSH tunnel. Use credentials for the source database, rather than Altertable lakehouse credentials.

Connect the catalog

  1. Open Catalogs and choose New catalog.
  2. Select Supabase as the engine.
  3. Fill in the connection details:
    • Host: The hostname or IP address of your Supabase server
    • Port: The port number (default: 5432)
    • Database: The name of the database to connect to
    • Schema (optional): The name of the schema to connect to
    • Username: Your Supabase username
    • Password: Your Supabase password
  4. Choose Connect to create the catalog.
New Supabase connection form

Verify the connection

Open SQL Explorer and inspect the new catalog's schemas and tables. Replace the example identifiers with names from your source:

SQL
SELECT * FROM my_source.my_schema.my_table LIMIT 10;

Compare the returned rows with the source. You can then join tables across catalogs.

Caveats

You will need to use Transaction Pooler connection method. Direct connection and session pooler methods don't work with Altertable for now.