---
title: "Warehouse"
description: "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."
---

> Documentation Index
> Fetch the complete documentation index at: https://docs.ezghcloud.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Warehouse

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

Source: https://docs.ezghcloud.com/warehouse/index.mdx
