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 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
-
Click ClickHouse® under Data & Analytics on the side menu. The Data Warehouse for ClickHouse® page displays.
-
Click + Create deployment. The Data Warehouse deployment creation wizard displays.
-
Select the region in which to create your deployment.
-
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.
-
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.
-
Select a ClickHouse® version.
-
Configure the administrator credentials for your deployment by entering a password or generating a random one.
-
Enter a name for your deployment, or keep the automatically generated one.
-
Optionally, you can use the cost estimator to simulate the cost of your deployment.
-
Click Create deployment to confirm.
A list of your Data Warehouse for ClickHouse® deployments displays, showing the newly created resources.