ClickHouse

Add ClickHouse as an external catalog when you want to query ClickHouse data from Altertable and join it with other lakehouse sources.

Connect ClickHouse

1. Open Catalogs in the Altertable app.
2. Click New catalog.
3. Select ClickHouse.
4. Fill in the connection details:
   • Host: ClickHouse hostname or IP address.
   • Port: ClickHouse port.
   • Database: Database to connect to.
   • Schema (optional): Schema or namespace to use when applicable.
   • Username: ClickHouse user.
   • Password: Password for the user.
5. If the database is not publicly reachable, configure an SSH tunnel through a bastion host.
6. Click Save.

Once connected, query ClickHouse tables and join them to other catalogs in the same SQL statement.