How to manage databases in your Data Warehouse for ClickHouse® deployment

Reviewed on June 03, 2025

This page explains how to manage databases in your Data Warehouse for ClickHouse® deployment.

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
• Created a Data Warehouse deployment

How to manage databases using the Scaleway console

The Scaleway console allows you to create and delete databases for your Data Warehouse for ClickHouse® deployment.

How to create a database using the Scaleway console

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

2. Click the name of the desired Data Warehouse deployment. The Overview tab of the deployment displays.

3. Click the Databases tab. A list of your current databases displays.

4. Click + Create database. A pop-up displays.

5. Enter a name for your new database. It can can only contain alphanumeric characters, underscores, and dashes.

6. Click Create database to confirm.

Your new database appears in the list.

How to delete a database using the Scaleway console

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

2. Click the name of the desired Data Warehouse deployment. The Overview tab of the deployment displays.

3. Click delete icon next to the name of the database you want to delete. A confirmation pop-up displays.

4. Enter DELETE, then click Delete database to confirm.

The deleted database no longer appears in the list.

How to manage databases using frameworks

Connect to your deployment using your preferred framework.

Once connected, you can run SQL queries to CREATE/ALTER/DROP your DATABASE/TABLE.

Refer to the official ClickHouse® documentation on database management for more information.