How to create a Data Warehouse for ClickHouse® deployment

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 startLink to this anchor

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
• Signed up to the private beta and received a confirmation email.

Creating a Data Warehouse DeploymentLink to this anchor

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 enter the vCPU autoscaling minimum and maximum values, and the number of nodes for your deployment.

5. Enter a name for your deployment, or keep the automatically generated one.

6. Configure the administrator credentials for your deployment by entering a password or generating a random one.

   Note

   The username cannot be modified.

7. Click the + Advanced settings button, then configure the following elements:

   • Select a ClickHouse® version.
   • Customize your deployment’s storage according to your needs.
   • Select a network configuration.

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

9. Click Create deployment to confirm. A list of your Data Warehouse for ClickHouse® deployments displays, showing the newly created resources.