---
title: "ClickHouse DBMS With Wasabi"
slug: "clickhouse-with-wasabi"
updated: 2026-05-28T17:20:30Z
published: 2026-05-28T17:20:30Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wasabi.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ClickHouse DBMS With Wasabi

[ClickHouse](https://clickhouse.com/) has been validated for use with Wasabi Object Storage. ClickHouse is a high-performance, open-source, column-oriented database management system (DBMS) designed for online analytical processing (OLAP) and real-time data analytics.

#### Prerequisites

- ClickHouse Server v.23.0 or later
- ClickHouse Backup Tool (Optional, but recommended)
- ClickHouse Open Source or Paid Version
- Active Wasabi Object Storage Account
- Wasabi Access Keys
- Wasabi Bucket

## Reference Architecture Diagram

![](https://cdn.document360.io/bef0a1ea-7768-4d5a-b520-c4fe2f7fafad/Images/Documentation/image-JPAFX2NF.png)

## Configuration

### Creating a Wasabi Bucket

1. Log in to the Wasabi Console.
2. Click **Buckets** then click **Create Bucket**.
3. Enter a name (for example, “clickhouse-backup”).
4. Select a region (for example, us-east-1).
5. Be sure to keep Versioning and Object Lock disabled.
6. Click **Create**.

### Creating an IAM Sub-User

1. ### Click **Users** then click **Create User**.
2. Assign a name for the user (for Example, “clickhouse-s3-user).
3. Select **Programmatic Access**.
4. Create a new Group using the policy below:

`{`

`  "Version": "2012-10-17",`

`  "Statement": [`

`    {`

`      "Effect": "Allow",`

`      "Action": [`

`        "s3:GetBucketLocation",`

`        "s3:ListAllMyBuckets"`

`      ],`

`      "Resource": "arn:aws:s3:::*"`

`    },`

`    {`

`      "Effect": "Allow",`

`      "Action": "s3:*",`

`      "Resource": [`

`        "arn:aws:s3:::clickhouse-backup",`

`        "arn:aws:s3:::clickhouse-backup/*"`

`      ]`

`    }`

`  ]`

`}`

1. Finish and download the Access and Secret Keys.

### Installing ClickHouse

If ClickHouse is not installed, below is an example for Linux - Ubuntu:

`sudo apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4`

`echo "deb https://packages.clickhouse.com/deb stable main" | sudo tee /etc/apt/sources.list.d/clickhouse.list`

`sudo apt update`

`sudo apt install clickhouse-server clickhouse-client -y`

`sudo systemctl start clickhouse-server`

### Configuring S3 Disk in ClickHouse

1. Create a file /etc/clickhouse-server/config.d/backup_disk.xml.

`<clickhouse>`

`  <storage_configuration>`

`    <disks>`

`      <s3_backup>`

`        <type>s3</type>`

`        <endpoint>https://s3.ap-southeast-1.wasabisys.com/clickhouse-backup/</endpoint>`

`        <access_key_id>YOUR_ACCESS_KEY</access_key_id>`

`        <secret_access_key>YOUR_SECRET_KEY</secret_access_key>`

`        <s3_max_single_part_upload_size>10485760</s3_max_single_part_upload_size>`

`        <upload_part_size>67108864</upload_part_size>`

`        <s3_max_put_rps>25</s3_max_put_rps>`

`        <metadata_path>/var/lib/clickhouse/disks/s3_backup/metadata</metadata_path>`

`      </s3_backup>`

`    </disks>`

`  </storage_configuration>`

`</clickhouse>`

1. Restart ClickHouse.

`sudo systemctl restart clickhouse-server`

1. Check log /var/log/clickhouse-server/clickhouse-server.log for confirmation.

### Installing ClickHouse-Backup Tool (Optional)

This tool simplifies backup/export and upload to S3:

`wget https://github.com/AlexAkulov/clickhouse-backup/releases/download/v2.5.3/clickhouse-backup`

`chmod +x clickhouse-backup`

`sudo mv clickhouse-backup /usr/local/bin/`

### Configuring ClickHouse-Backup Tool

Edit /etc/ClickHouse-backup/config.yml.

`general:`

`  remote_storage: s3`

`  disable_progress_bar: true`

`s3:`

`  bucket: clickhouse-backup`

`  endpoint: s3.ap-southeast-1.wasabisys.com`

`  access_key: YOUR_ACCESS_KEY`

`  secret_key: YOUR_SECRET_KEY`

`  use_path_style: true`

`  compression_format: tar`

`  compression_level: 1`

### Running Backup and Restoring Operations

Backup a specific database:

`clickhouse-backup create my_backup`

` clickhouse-backup upload my_backup`

Restore a specific database:

`clickhouse-backup download my_backup`

`clickhouse-backup restore my_backup`

### Verification on Wasabi

1. Navigate to the Wasabi Console.
2. Open the “clickhouse-backup” bucket.
3. Verify that the backup folder/files exist.