Use play UI#

ClickHouse® includes a built-in user interface for running SQL queries. You can access it from a web browser over the HTTPS protocol. Follow these steps to use it:

  1. Log in to the Aiven web console, choose the right project, and select your Aiven for ClickHouse service.

  2. In the Overview tab, find Connection information and select ClickHouse HTTPS.

  3. Copy the Service URI and navigate to SERVICE_URI/play from a web browser.

  4. Set the name and the password of the user on whose behalf you want to run the queries.

  5. Enter the body of the query.

  6. Click Run.

Note

The play interface is only available if you can connect directly to ClickHouse from your browser. If the service is restricted by IP addresses or in a VPC without public access, you can use the query editor instead. The query editor can be accessed directly from the console to run requests on behalf of the default user.