---
title: Data Warehouse for ClickHouse® features and limitations
description: This page presents the different features and limitations of Data Warehouse for ClickHouse®
tags: data warehouse clickhouse features specs data sheet limits limitations
dates:
  validation: 2025-11-25
  posted: 2025-11-25
---

This page lists the different features and limitations of Scaleway Data Warehouse for ClickHouse®.

## Features

### Load Balancer

Every Scaleway Data Warehouse for ClickHouse® deployment comes automatically with a [Load Balancer](/load-balancer/), even for deployments consisting of only 1 node. 

This Load Balancer automatically balances the queries over the different nodes of your deployment. It is therefore not possible to know which node will process a query.

### Data replication

For better reliability and ease of use, Data Warehouse for ClickHouse® replicates the data across all replicas of a deployment.

Replication is achieved by aliasing commands:
 
| Default command              | Replaced by |
|------------------------------|-------------|
| `CREATE DATABASE <database>` | `CREATE DATABASE <database> ON CLUSTER <Scaleway cluster>` |
| `DELETE DATABASE <database>` | `DELETE DATABASE <database> ON CLUSTER <Scaleway cluster>` |

Creating a table in the `MergeTree` family will also be aliased in order to create the **Replicated** version:

| Default table                | Replaced by                            |
|------------------------------|----------------------------------------|
| MergeTree                    | ReplicatedMergeTree                    |
| ReplacingMergeTree           | ReplicatedReplacingMergeTree           |
| CoalescingMergeTree          | ReplicatedCoalescingMergeTree          |
| SummingMergeTree             | ReplicatedSummingMergeTree             |
| AggregatingMergeTree         | ReplicatedAggregatingMergeTree         |
| CollapsingMergeTree          | ReplicatedCollapsingMergeTree          |
| VersionedCollapsingMergeTree | ReplicatedVersionedCollapsingMergeTree |
| GraphiteMergeTree            | ReplicatedGraphiteMergeTree            |

<Message type="note">
If no table engine is specified at table creation, Data Warehouse for ClickHouse® will use `ReplicatedMergeTree` by default.
</Message>

Refer to the [official ClickHouse® documentation](https://clickhouse.com/docs/engines/table-engines/mergetree-family) for more information on the `MergeTree` table family.