---
title: How to manage databases in your Data Warehouse for ClickHouse® deployment
description: Learn how to manage databases in your Scaleway Data Warehouse for ClickHouse® deployment.
tags: manage databases data warehouse clickhouse admin administrator db table create drop delete
dates:
  validation: 2025-06-03
  posted: 2025-06-03
---
import Requirements from '@macros/iam/requirements.mdx'


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

<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
- Created a [Data Warehouse deployment](/data-warehouse/how-to/create-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 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

<Message type="note">
The `default` database cannot be deleted.
</Message>

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 <Icon name="delete" /> 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](/data-warehouse/how-to/connect-applications/) using your preferred framework.

<Message type="tip">
You can also connect using the ClickHouse HTTP console from the **Overview** tab of your deployment. Make sure to enter valid credentials in the top-right fields.
</Message>

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

Refer to the official ClickHouse® documentation on [database management](https://clickhouse.com/docs/starter-guides) for more information.