The Cluster Explorer

Working directly with a ClickHouse® cluster

The Altinity Cloud Manager UI provides the Cluster Explorer, 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.

The top of the page looks like this:

Menus and buttons in the Cluster Explorer

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.
    The Cluster menu
  • RUN DDLs ON CLUSTER - If selected, Distributed DDL Queries are run on the cluster.
  • NODE menu - Lets you select the scope of anything you do in the Cluster Explorer. For the maddie-byok cluster, the menu looks like this:
    Menus and buttons in the Cluster Explorer
    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.
  • - 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.

See the following pages for details:


The Query tab

Execute SQL statements in your ClickHouse® cluster

The Schema tab

View the databases and tables in your ClickHouse® cluster

The Workload tab

See what’s happening in your ClickHouse® cluster

The DBA Tools tab

Use system-level tools to investigate your ClickHouse® cluster

Importing a Dataset

Loading sample data into your ClickHouse® cluster