How to create a Data Warehouse for ClickHouse® deployment

Reviewed on January 05, 2026

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.

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions 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.

   Note

   The username cannot be modified.

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.