Is it possible to deploy ClickHouse with separate storage and compute?
This page provides an answer as to whether it is possible to deploy ClickHouse with separate storage and compute
The short answer is “yes”.
Object storage (S3, GCS) can be used as the elastic primary storage backend for data in ClickHouse tables. S3-backed MergeTree and GCS-backed MergeTree guides are published. Only metadata is stored locally on compute nodes in this configuration. You can easily upscale and downscale compute resources in this setup as additional nodes only need to replicate metadata.