Was this page helpful?

How to manage users in Scaleway Data Warehouse for ClickHouse®

Reviewed on 03 June 2025 • Published on 03 June 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 startLink to this anchor

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 consoleLink to this anchor

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 frameworksLink to this anchor

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.