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.
Create a warehouse
Shards, replicas, the Keeper mode, size, storage, who can connect and maintenance.
Connect clients and BI tools
HTTPS and the native protocol, TLS and the CA bundle, the plaintext ports and ezgh warehouse connect.
Users and grants
Presets, grants, settings profiles, and passwords in Secrets.
Databases and tables
Replicated databases, ReplicatedMergeTree tables and the schema browser.
Sharding and Distributed tables
Spread rows across shards and query every shard at once.
Durability
When an insert is acknowledged, insert_quorum and insert_distributed_sync.
Load data
Connections to buckets, Hosted Queues Kafka clusters and Databases.
Query editor
Run SQL from the console.
Scaling
Add shards and replicas, change the size and grow storage.
Backups and restore
Daily backups, on-demand backups and restores into a new warehouse.
Upgrades
Moving a warehouse to a newer ClickHouse version.
Monitoring
Metrics in Observability and the built-in dashboard.
Limits
Shapes, query limits and quotas.
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.