Skip to content

Metabase

Metabase ships PostgreSQL and Snowflake drivers; the ClickHouse driver is an official plugin (clickhouse.metabase-driver.jar) placed in plugins/.

Driver Field Before After
PostgreSQL Host / Port postgres.internal / 5432 warehouse.internal / 5432
ClickHouse Host / Port / Use a secure connection clickhouse.internal / 8443 / on warehouse.internal / 8443 / on
Snowflake Account name myorg-myaccount demo
Snowflake Additional JDBC connection string options (empty) host=warehouse.internal&port=443&ssl=on

Steps: Admin settings → Databases → Add database, choose the driver, fill the fields above, user and password, save. Sync and fingerprinting run their usual introspection queries, which MachWarehouse answers from its catalog.

Tip: keep Rerun queries for simple explorations on; repeated questions are served from the warehouse result cache.