Skip to content

Warehouse

Managed ClickHouse data warehouses in your VPC, with shards and replicas, users whose passwords live in Secrets, loading from your buckets, Kafka and databases, and metrics in Obs.

Updated View as Markdown

EZGH Warehouse runs ClickHouse for you, in a subnet of your VPC, for analytics on billions of rows: events, orders, metrics and logs. A warehouse is a grid of shards × replicas. You connect any ClickHouse client or BI tool to its name with a user and password that are already in Secrets, load data from your buckets, Hosted Queues Kafka clusters and databases with one SQL statement, and add shards or replicas as it grows.

The Warehouse API is at https://warehouse-api.ezghcloud.com. In the console, open Warehouse.

At a glance

Engine ClickHouse, LTS versions 26.3 and 26.8
Shape 1–8 shards × 1–3 replicas
Ports 8443 (HTTPS) and 9440 (native, TLS); 8123 (HTTP) and 9000 (native) optional
Authentication Username and password
Cluster name default
Loading s3(), the Kafka table engine, postgresql() and mysql() through connections
Backups Daily, kept 1–35 days, restored into a new warehouse

IAM

Actions are warehouse.<collection>.<verb>, such as warehouse.warehouses.create, warehouse.warehouses.query and warehouse.databases.delete. The managed policies are WarehouseFullAccess and WarehouseReadOnlyAccess; ReadOnlyAccess includes Warehouse’s list and get actions.

Navigation

Type to search…

↑↓ navigate↵ selectEsc close