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:
SELECT COUNT(*) FROM transactions.accounts
Create a new role:
CREATE ROLE accountant