Use the query editor

Aiven for ClickHouse® includes a web-based query editor, which you can find on the Query Editor tab of your service in the Aiven web console.

The requests that you run through the query editor are executed on behalf of the default user and rely on the permissions granted to this user.

Examples of queries

Retrieve a list of current databases:

SHOW DATABASES

Count rows:

SELECT COUNT(*) FROM transactions.accounts

Create a new role:

CREATE ROLE accountant