How to manage users in Scaleway Data Warehouse for ClickHouse®

Reviewed on June 03, 2025

This page explains how to manage users in your Data Warehouse for ClickHouse® deployment using the Scaleway console.

Note

During the private beta phase, user management can only be done with the scwadmin user via the ClickHouse® CLI, MySQL or HTTPS protocols.

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

How to manage users using the Scaleway console

During the private beta phase, the management of users for your Data Warehouse for ClickHouse® deployment is limited to:

Viewing users in your deployment
Changing the password of an existing user

How to manage users using frameworks

Connect to your deployment using your preferred framework.

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.

Once connected, you can run SQL queries using USER, ROLE, and ROW POLICY to create new users and grant them the desired permissions via roles.

Refer to the official ClickHouse® documentation on users and roles for more information.