The Query tab

Execute SQL statements in your ClickHouse® cluster

When you open the Cluster Explorer, you’ll be on the Query tab:

Query Page

Figure 1 - The Query tab

The text area at the top of the panel lets you run SQL statements by clicking the EXECUTE button. (You can also keep your hands on the keyboard by typing Ctrl or CMD + Enter.)

Beneath the text area are helpful notes with links to ClickHouse® documentation and a couple of example queries.

When you execute a query, the results appear under the text area:

Query results

Figure 2 - Query results

Above the text area, the left and right arrows let you move through the queries you’ve executed. The button brings up the Select User dialog:

The Select User dialog

Figure 3 - Changing the user to access the cluster

This lets you select the user (and their permissions) to run the query. The down arrow lets you choose from the users defined for this cluster. If your account has the necessary permissions, you can also click the link in Manage ClickHouse users here to go directly to the user management panel.