Getting started with ClickHouse

Connect to your ClickHouse instance, explore EDB-specific capabilities, and find resources for going further.

Connecting to ClickHouse

Once ClickHouse is installed and running, connect using clickhouse-client :

clickhouse-client

Verify you’re running an EDB-packaged build:

SELECT value FROM system.build_options WHERE name = VERSION_OFFICIAL;

Integrations

• Connecting ClickHouse to WarehousePG : read from and write to WarehousePG tables using the PostgreSQL table engine

• Integrating with Iceberg catalogs : query Iceberg tables stored in Amazon S3 or Azure Blob Storage

See also

For SQL reference, configuration, and operational guidance beyond what’s covered here, refer to the upstream ClickHouse documentation:

• Creating tables

• Inserting data

• Writing queries

• SQL reference

• Table engines

• Server configuration

• Best practices