---
title: How to create a Data Warehouse for ClickHouse® deployment
description: This page provides a guide on how to set up a Data Warehouse using ClickHouse® using the Scaleway console.
tags: clickhouse data-warehouse deployment
dates:
  validation: 2026-01-05
  posted: 2025-06-03
---

import Requirements from '@macros/iam/requirements.mdx'

A Data Warehouse is a centralized repository designed to store, manage, and analyze large volumes of structured and semi-structured data. When powered by ClickHouse®, it provides performance for real-time analytics and complex queries. This guide will walk you through the steps to deploy a Data Warehouse for ClickHouse® deployment using the Scaleway console.

<Requirements />

- A Scaleway account logged into the [console](https://console.scaleway.com)
- [Owner](/iam/concepts/#owner) status or [IAM permissions](/iam/concepts/#permission) allowing you to perform actions in the intended Organization

## Creating a Data Warehouse Deployment

1. Click **ClickHouse®** under **Data & Analytics** on the side menu. The Data Warehouse for ClickHouse® page displays.

2. Click **+ Create deployment**. The Data Warehouse deployment creation wizard displays.

3. Select the **region** in which to create your deployment.

4. Choose an autoscaling configuration:
    - **Presets**: select one of several pre-configured deployments adapted to the most common use cases.
    - **Custom**: manually configure:
        - **Node configuration**: minimum and maximum vCPU values for your deployment.
        - **Sharding**: the number of shards for your deployment. This value cannot be changed after creation.
        - **Replication**: the number of replicas per shard. This value can be edited after deployment creation.

5. Configure at least one type of network connectivity for your deployment:
    - Attach an existing Private Network, or create a new one to securely communicate with other resources within this Private Network.
    - Set up public connectivity to access your deployment over the public internet.

6. Select a ClickHouse® version.

7. Configure the administrator credentials for your deployment by entering a password or generating a random one.
    <Message type="note">
    The username cannot be modified.
    </Message>
  
8. Enter a name for your deployment, or keep the automatically generated one.

9. Optionally, you can use the cost estimator to simulate the cost of your deployment.

10. Click **Create deployment** to confirm.

A list of your Data Warehouse for ClickHouse® deployments displays, showing the newly created resources.