The Altinity Cloud Manager UI provides the SQL Console, a panel that lets you run queries against your ClickHouse® databases, work with database schemas, look at processes running inside the cluster, and use a number of useful DBA tools.
NOTE: The SQL Console was previously known as the Cluster Explorer.
The top of the page looks like this:
The functions of the buttons and menus are:
- The back button. Takes you back to the cluster view for this cluster.
CLUSTER menu - Clicking this menu displays a dropdown list of all of the clusters in this environment. Whatever you do in the Cluster Explorer will be done on the selected cluster.
NODE menu - Lets you select the scope of anything you do in the Cluster Explorer. For the sample-cluster cluster, the menu looks like this:
Selecting Any means everything you do will be executed on a single node selected by the load balancer. All executes everything on every node. Beyond those two choices, you can select a node from the list of all nodes in this cluster.
- The back button. Takes you back to the cluster view for this cluster.
- lets you import a sample dataset into your ClickHouse cluster. The Importing a Dataset page has complete details.
- The refresh button. Refreshes the display, as you would expect.