Welcome to Altinity.Cloud! Altinity.Cloud is the fastest, easiest way to set up, administer and use ClickHouse. Your ClickHouse is fully managed so you can focus on your work.
If this is your first time using Altinity.Cloud, this quick start guide will give you the minimum steps to become familiar with the system. When you’re ready to dig deeper and use the full power of ClickHouse in your Altinity.Cloud environment, check out our Administrator and Developer Guides for in depth knowledge and best practices.
1 - Altinity Cloud Manager Introduction
An overview of using the Altinity Cloud Manager (ACM) to managing your ClickHouse clusters with Altinity.Cloud.
26 January 2023 · Read time 3 min
Overview - Altinity Cloud Manager
This section introduces the Altinity Cloud Manager for managing ClickHouse cluster environments.
The Altinity Cloud Manager (ACM) is where your existing clusters are shown.
https://acm.altinity.cloud/clusters/
Points of interest marked by the red pins include:
The your.environment name is what you signed up with, otherwise a cluster name appears hear in this menu.
The John Doe is an example of your logged-in name.
The left pane collapses or expands the text labels beside the icons.
The Launch Cluster text tag refers to the call-to-action LAUNCH CLUSTER button.
Figure 1 – The Altinity Cloud Manager (ACM) home screen with no clusters showing.
Looking at the Demo
To switch to the demo environment:
Use the environment menu to switch to demo to see the clusters.
Figure 2 – The environment menu, where the demo name is selected.
The demo environment has several example clusters:
posthog
clickhouse101
meetup
github
Panel View
To see the detail for the cluster named clickhouse101:
In the cluster named clickhouse101, hover over pane, the outline turns blue, then click .
Figure 3 – The demo environment showing several cluster panels.
List View
The list view provides a spreadsheet table view of your clusters.
Select the List View icon.
Figure 4 – The list view of all the demo clusters.
Cluster Dashboard view
Selecting a cluster name from a panel view or list view displays the settings that were set by the Cluster Launch Wizard.
Figure 5 – Detailed settings view of the cluster clickhouse101.
Explore View
While viewing your cluster, selecting the Explore button displays the Query screen. This is where SQL queries are run on your cluster. Note the additional tabs for Schema, Workload and DBA Tools.
Figure 6 – The cluster Query tab screen. This is where SQL queries are run.
Grafana Monitoring View
From your cluster dashboard view, selecting the MonitoringView in Grafana link displays the graphs shown in the following screenshot.
Figure 7 – The Grafana graphs for the K8S Namespacedemo, for the cluster named clickhouse101.
A Wizard-Created Cluster
When you create a new cluster using the LAUNCH CLUSTER Wizard, the example-environment-name appears in your Altinity Cloud Manager (ACM).
Points of interest include:
example-environment - Menu name changes to the selected environment (aka namespace or domain). 2/2 nodes online - Green to indicate running status. Action > Stop to take offline. 0/2 nodes online - Red shows nodes are not running. Action > Resume to start. stopped - Cluster / node is not running. Action > Resume to start. 6/6 checks passed - Shows green when all 6 checks have completed successfully. 0/6 checks passed - Shows red until all checks have passed. Action > Resume to start. Shield green - TLS (Transport Layer Security) is enabled. Actions - Mouse hover shows this light blue shade. Blue outline - In cluster panel view, moving your mouse cursor over a cluster changes the grey outline to blue; click to view. Panel view icon - View clusters in panel format. List view icon - View cluster in a list format. Address of all clusters - https://acm.altinity.cloud/clusters/ Address of a specific cluster - https://acm.altinity.cloud/cluster/2887
Figure 8 – Points of interest from the newly created example-cluster.
2 - Account Creation and Login
How to set up your Altinity.Cloud account, and login to the service.
26 January 2023 · Read time 2 min
Free Trial Account Creation
To start your Altinity.Cloud journey, the first thing you need is an account.
New users can sign up for a 14-day Trial account from the following link:
Requested information as shown in the following screenshot includes:
First Name and Last Name
Email (if you provide a Google business email account (this does not include person @Gmail emails), you can login with Auth0 login)
Company name
Country
Cloud Provider that you use (Examples: Amazon, Google)
Your managed environment name (eg: my-staging)
Email Validation
When you SUBMIT the Free 14-day Trial form, you will immediately receive an email from Altinity with a validation link that you click to confirm.
First Time Login
Once you validate your email, your request for the Altinity.Cloud free trial will be processed for approval.
The Altinity.Cloud (support@altinity.com) team will provide the following login information.
The following example screenshot is an email that you will receive from Altinity.Cloud notifying you that your 14-day Free Trial to Altinity.Cloud has been approved.
Your-altinity is an example of the environment name you supplied Altinity.
(NOTE: If your name choice already exists in our system, we will rename it.)
The URL is customized to you and is used once only for the initial login.
Here refers to a Calendar linkhttps://calendly.com/trial-support-team/altinity-cloud-trial-check
Password (example: S0me@c0pl3x_password - •••••••••••••••••••• dots show as you type)
Auth0 login
AUTH0 is used to login if you have a Google Gmail account that Altinity.Cloud supports for trusted authentication.
Note that in order for this to work, you must have used your Gmail address to register for the Altinity.Cloud Free Trial.
If you are not already logged into a Google domain, the usual Google login screen appears. Select the same Google domain email address you
registered with Altinity.Cloud to complete the login.
NOTE: This does not includ
This is an introduction to the cluster Explore > Query feature. You will learn how to select a cluster from the included demo and run a SQL query and view the results.
26 January 2023 · Read time 3 min
Overview - Using the cluster Explore > Query
This example shows how to navigate from the cluster home page and how to use Explore > Query to run a query a ClickHouse database on the included demo cluster called github.
The following screenshot shows the step-by-step sequence of events, starting from your cluster home page (A), then selecting the ClickHouse database repository demo github cluster against which you will run the example SQL query in the Explore > Query screen (B).
To run a SQL query from the demo cluster named github:
Within the cluster called github, select EXPLORE.
Note that the URL changes to:
https://acm.altinity.cloud/cluster/337/explore (see Figure 2 B-1) .
Note that the menu title shows that CLUSTER:GITHUB is selected (see Figure 2 B-3).
Figure 2 – The Explore of the demo > github cluster viewing the Query tab.
SQL Query script
The following SQL script generates a 3-column report from a github database from 2019 to 2023 that the collates the number of pull requests (PRs) made by unique contributors.
Code snippet 1 – The input, an example SQL query script to get 4 years of unique pull request contributor totals.
Query explanation
The SQL query visualization shows the Input (green) data sources and Output (red) 3 columns M, PRs and Contributors.
Figure 3 – The example SQL query script and visualization.
First select the start of the year for the merged_at column (line 1), the sum of the merged column (m), and the unique values in the creator_user_login column from the github_events table (line 2).
Include only the rows where the merged_at column is on or after January 1, 2019 (line 3) and the event_type column is ‘PullRequestEvent’ (line 4) and the repo_name column is either ‘ClickHouse/ClickHouse’ or ‘yandex/ClickHouse’ (line 5).
Group the results (line 6) by the start of the year for the merged_at column (from line 3)
Lastly, order the results (line 7) by the start of the year for the merged_at column.
SQL Query results
The results of the query appear below the EXECUTE button, listing 3 columns titled m (year), PRs and Contributors.
Code snippet 2 – The output, 3 columns of year (m), PRs and contributors showing 4 years of unique pull request contributor totals.
4 - Cluster Launch Wizard
An introduction to the Cluster Wizard, used to create a new ClickHouse cluster. An overview of the settings is provided, with links to further details.
26 January 2023 · Read time 5 min
Overview - Cluster Launch Wizard (summary)
This section covers the Altinity Cloud Manager ClickHouse cluster creation feature called the Cluster Launch Wizard. This getting started guide walks you through the steps to create a new cluster from scratch.
The Detailed reference link takes you to section on the Wizard Settings Detail page that explains each setting.
Where indicated, additional settings and resources can be obtained upon request from Altinity Technical Support at:
https://altinity.com/contact/
The following wizard screens are covered on this page:
The following illustration shows a summary of the various screens available in the Cluster Wizard.
Figure 1 – Each of the Restore Wizard screens and the available settings.
Launch Cluster
The Altinity Cloud Manager (ACM) is where your existing clusters are shown.
https://acm.altinity.cloud/clusters/
If this is the first time you have seen this page, or you have deleted all of your clusters, this page will be blank and show the text string:
"You don’t have any clusters running at this moment."
Points of interest marked by the red pins include:
The your.environment name is what you signed up with. Note that a read-only demo environment is included.
The John Doe is an example of your logged-in name.
The left pane collapses or expands the text labels beside the icons.
The Launch Cluster text tag refers to the call-to-action LAUNCH CLUSTER button.
To begin the creation of a new ClickHouse cluster:
Select the LAUNCH CLUSTER button.
Figure 2 – The Altinity Cloud Manager (ACM) home page, selecting the LAUNCH CLUSTER button.
Starting with the ClickHouse Setup screen, fill in the information required by each wizard screen clicking NEXT to navigate.
Figure 3 – Each of the 6 Cluster Launch Wizard screens and the available settings.
1. ClickHouse Setup
After selecting the LAUNCH CLUSTER button, the first wizard setup screen appears ClickHouse Setup.
NOTE: Click to view the password then copy and paste it to the Confirm Password field.
Figure 4 – The wizard screen 1 of 6 ClickHouse Setup.
2. Resources Configuration
The second screen is Resources Configuration, where you choose the CPU and storage settings.
If you need more resources that what is displayed, contact Altinity Support.
Figure 8 – The wizard screen 5 of 6 Uptime Schedule.
6. Review & Launch
There is nothing to add or change on this review screen.
This is last chance where you can use the BACK button and change previously entered settings, then return to this screen.
If there are no changes, select the LAUNCH button to save the settings and start the cluster provisioning process.
Figure 9 – The last wizard screen 6 of 6 Review & Launch.
Cluster view after Wizard finishes
The example-cluster appears in your Altinity Cloud Manager (ACM).
Any new cluster will appear as another panel or another row in a table listing.
Points of interest include:
example-environment - Menu name changes to the selected environment (aka namespace or domain).
2/2 nodes online - Green to indicate running status. Action > Stop to take offline.
0/2 nodes online - Red shows nodes are not running. Action > Resume to start.
stopped - Cluster / node is not running. Action > Resume to start.
6/6 checks passed - Shows green when all 6 checks have completed successfully.
0/6 checks passed - Shows red until all checks have passed. Action > Resume to start.
Shield green - TLS (Transport Layer Security) is enabled.
Actions - Mouse hover shows this light blue shade.
Blue outline - In cluster panel view, moving your mouse cursor over a cluster changes the grey outline to blue; click to view.
Panel view icon - View clusters in panel format.
List view icon - View cluster in a list format.
Address of all clusters - https://acm.altinity.cloud/clusters/Address of a specific cluster - https://acm.altinity.cloud/cluster/2887
Figure 10 – Points of interest from the newly created example-cluster.
5 - Wizard Settings Detail
Details for the various Cluster wizard settings.
26 January 2023 · Read time 11 min
Overview
Purpose
This section provides a detailed discussion of the settings that expands on the overview of the Cluster Launch Wizard.
Figure 2 – The Name of the cluster example-cluster in the ClickHouse Setup wizard screen.
The Name of your cluster must follow DNS name restrictions as follows:
Allowed
Name must start with a letter
Lower case letters (a to z)
Numbers (0 to 9)
Hyphens, also named dash or minus character (-)
15 character limit
Disallowed
Periods (.)
Special characters ( > ’ , " ! # )
UI Text
“Cluster name tag will be used in ClickHouse configuration and it may contain only lowercase letters [a-z], numbers [0-9] and hyphens [-] in between”
ClickHouse Version
This lets you choose which version of ClickHouse to use, from a list in the Altinity Builds category or any other ClickHouse Community Builds.
Figure 3– The ClickHouse software version number from the cluster wizard ClickHouse Setup screen.
Altinity Builds
Altinity Stable Builds are tested, proven stable builds with 6-month test cycles. They are based on ClickHouse Long Term Support (LTS) releases and are supported for up to 3 years. These release numbers include the phrase Altinity Stable Build.
This password will be assigned to the ClickHouse User
The minimum password length is 12 characters. Consider adding digits
capital letters and special symbols to make password more secure
CPU and RAM sizes for the node. The names in the drop-down menu will differ depending on which environment you are using. (E.g., between AWS and GCP.)
Contact Altinity Technical Support if you need additional node types.
Figure 6– The Node Type (CPU and RAM) from the cluster wizard Resources Configuration screen.
Clusters can later be scaled up or down dynamically.
“Node Type will be the same across all ClickHouse hosts”
Node Storage
The size of each cluster node in GB (gigabytes).
Figure 7– The Node Storage size in GB from the cluster wizard Resources Configuration screen.
Each node has the same storage area.
Example: 100 (GB)
UI Text
“Each ClickHouse host will have specified amount of local volume storage”
Number of Volumes
Depending on the cloud provider you are using, creating more volumes may improve query performance.
Figure 8– The Number of Volumes to set, from the cluster wizard Resources Configuration screen.
UI Text
“Network storage can be split to several volumes for a better query performance”
Volume Type
These are SSD block storage volumes provided by Amazone AWS, Google GCP, or other cloud providers.
The choices are:
gp2-encrypted
gp3-encrypted
Figure 9– The Volume Typegp2-encrypted or gp3-encrypted from the cluster wizard Resources Configuration screen.
UI Text
“Defines volume claim storage class for each ClickHouse host”
Number of Shards
Shards group nodes that work together to share data and improve performance. Replicating shards is done to increase availability and speed up recovery if one shard goes down.
Figure 10– The Number of Shards to create, from the cluster wizard Resources Configuration screen.
Where quotas are in place, the UI string “x / y (ie. 1 of 20) shards will be used”.
Figure 11– The Number of Replicas to create, from the cluster wizard High Availability Configuration screen.
1 | 2 | 3
Number of Replicas for each Cluster Shard
Replicas: x / y Replicas will be used (appears if Altinity Support has set usage quotas)
UI Text
“Number of Replicas for each Cluster shard”
Quotas set by Altinity
If bar charts appears, this means Altinity Support has set quotas for your domain.
Figure 12– The graphs for CPU and Storage appear if Altinity Support has set quotas. From the cluster wizard High Availability Configuration screen.
CPU: x / y vCPUs will be used
Storage: x / y GB will be used
Zookeeper Configuration
Figure 13–The Zookeeper Configuration and Zookeeper Node Type from the cluster wizard High Availability Configuration screen.
Example: Dedicated
UI Text
“You can pick a shared Zookeeper cluster, Launch a dedicated one or do not use Zookeeper at all.”
Zookeeper Node Type
Default
Enable Backups
Whether or not backups occur.
Figure 14–The Enable Backups checkbox and Backup Schedule from the cluster wizard High Availability Configuration screen.
Example: True (checked)
Backup Schedule
This is the frequency that data backups happen.
Example: Daily
UI Text
[ none ]
Number of Backups to keep
Figure 15–The Number of Backups to keep from the cluster wizard High Availability Configuration screen.
Figure 19– The Protocols ports to enable, from the cluster wizard Connection Configuration screen.
Datadog integration
For logging purposes, you can request that the third-party application Datadog be set up by Altinity Support.
Datadog integration (disabled) - This entire section is dimmed.
Send Logs = False (unchecked)
Send Metrics = False (unchecked)
Figure 20– If Altinity Support has enabled this, Datadog integration is selectable. From the cluster wizard Connection Configuration screen.
UI Text
[ none ]
IP restrictions
This is used to increase security by using a whitelist, or allowlist of IP numbers to restrict access.
Note that Altinity needs to have certain ports open in order to maintain your tenancy.
IP restrictions
EnabledFalse (unchecked) - This is the default setting
Enabled True (checked) - Turn on this setting then add IP numbers
Figure 21– If Altinity Support has enabled this, *IP restrictions lets you whitelists IP numbers. From the cluster wizard Connection Configuration screen.
UI Text
Restricts ClickHouse client connections to the provided list of IP addresses in CIDR format. Multiple entries can be separated by new lines or commas
Note: 34.238.65.247, 44.195.72.25, 100.24.75.12, 10.0.0.0/8, 172.16.0.0/12, 192.168.0.0/16, 10.128.0.0/23, 10.128.2.0/23, 10.128.4.0/23
is added automatically as it is required for Altinity.Cloud to operate.
Uptime Schedule
Used to set a schedule for when the clusters should run. (Screen 5 of 6)
For this Quick Start Guide, the servers are set to ALWAYS ON.
Always On | Stop When Inactive | On Schedule
To see the full-sized Uptime Schedule screen, see:
How to install the ClickHouse Ubuntu command line client and connect to your Altinity.Cloud cluster.
26 January 2023 · Read time 2 min
Overview - Ubuntu ClickHouse Client
This section covers the installation of the ClickHouse client on the Linux OS Ubuntu 20.04.
After installation, you will be able to run use ClickHouse queries from the terminal.
After you enter your ClickHouse cluster password, you enter the ClickHouse interactive mode. ClickHouse prompt example:example-cluster :)
(test2) user@xubuntu:~$ clickhouse-client -h example-cluster.your-domain.altinity.cloud --port 9440 -s --user=admin --password
ClickHouse client version 22.12.3.5 (official build).
Password for user (admin):
*********
Connecting to example-cluster.your-domain.altinity.cloud:9440 as user admin.
Connected to ClickHouse server version 22.3.15 revision 54455.
ClickHouse server version is older than ClickHouse client.
It may indicate that the server is out of date and can be upgraded.
example-cluster :)
ClickHouse query examples
At the ClickHouse prompt, enter the query command show tables:
example-cluster :) show tables
SHOW TABLES
Query id: c319298f-2f28-48fe-96ca-ce59aacdbc43
┌─name─────────┐
│ events │
│ events_local │
└──────────────┘
2 rows in set. Elapsed: 0.080 sec.
At the ClickHouse prompt, enter the query select * from events:
example-cluster :)select * from events
SELECT *
FROM events
Query id: 0e4d08b3-a52d-4a03-917d-226c6a2b00ac
┌─event_date─┬─event_type─┬─article_id─┬─title───┐
│ 2023-01-04 │ 1 │ 13 │ Example │
│ 2023-01-10 │ 1 │ 13 │ Example │
│ 2023-01-10 │ 1 │ 14 │ Example │
└────────────┴────────────┴────────────┴─────────┘
3 rows in set. Elapsed: 0.073 sec.
To quit, or exit from the ClickHouse interactive mode:
Enter the exit command to return to your Ubuntu shell environment.
example-cluster :)exitBye.
This completes the quick start guide to installing ClickHouse command-line client on an Ubuntu OS.
Problem result: Cannot connect to ACM Cluster with clickhouse-client terminal command.
ubuntu@ip-172-31-16-238:~$ clickhouse-client -h test-anywhere.awsanywhere.altinity.cloud --port 9440 -s --user=admin --password=supersecretpassword123
# Error response: note the older version of the ClickHouse client v18.16.1ClickHouse client version 18.16.1.
Connecting to test-anywhere.awsanywhere.altinity.cloud:9440 as user admin.
Code: 210. DB::NetException: SSL connection unexpectedly closed (test-gap-anyw.awsanywhere.altinity.cloud:9440, 33.33.33.333)
Reason for the error
When you have an outdated version of the ClickHouse client software installed, you may fail to connect to your ACM cluster. The issue may be that a standard apt-get install or apt-get upgrade will not retrieve the latest version of the ClickHouse client as shown in this example terminal listing.
How to install the ClickHouse Python driver, and connect to your Altinity.Cloud ClickHouse Cluster from a Python program or a Python console.
26 January 2023 · Read time 4 min
Overview - Python ClickHouse Client
This section covers the installation and use of the Python ClickHouse client.
After installation, you will be able to run use ClickHouse queries on any platform that will run Python3.
Change the cluster name, replacing your-company-example
Change password yourpasswordhere to your own ClickHouse cluster name
Run the program from the terminal or your IDE:
python3 ClickHouse-example.py
Code Snippet 1 - ClickHouse-example.py
importclickhouse_driverprint(clickhouse_driver.__version__)# No return characters:# Replace your-company-example# Replace yourpasswordhere # client = Client('example-cluster.your-company-example.altinity.cloud', user='admin', password='yourpasswordhere', port=9440, secure='y', verify=False)# Connect to your clusterfromclickhouse_driverimportClientclient=Client('example-cluster.your-company-example.altinity.cloud',user='admin',password='yourpasswordhere',port=9440,secure='y',verify=False)# Show tablestables=client.execute('SHOW TABLES in default')print(tables)# Show dataresult=client.execute('SELECT * FROM default.events')print(result)# Show ClickHouse Python driver versionversion=(clickhouse_driver.__version__)print("ClickHouse Python version: ",version)
This section shows how you can use the Python console to interactively connect to your ClickHouse cluster on Altinity and send SQL queries.
First copy your Connection Details from your cluster you want to communicate with.
Bring up the terminal and enter Python console mode, then copy and paste the following commands shown after the Python console prompt »>:
# Get into Python console modepython3>>># Getting the ClickHouse Python driver version number>>>importclickhouse_driver>>>print(clickhouse_driver.__version__)0.2.5# Connect to your ClickHouse cluster (replace <HOSTNAME> and <PASSWORD>)>>>fromclickhouse_driverimportClient>>>client=Client('<HOSTNAME>',user='admin',password=<PASSWORD>,port=9440,secure='y',verify=False)# Confirm that the client object is created>>>print(client)<clickhouse_driver.client.Clientobjectat0x107730910># Show all tables>>>client.execute('SHOW TABLES in default')[('events',),('events_local',)]# Show data>>>result=client.execute('SELECT * FROM default.events')>>>print(result)[(datetime.date(2023,1,4),1,13,'Example'),(datetime.date(2023,1,10),1,13,'Example'),(datetime.date(2023,1,10),1,14,'Example')]# ClickHouse Version 0.2.5 as of January 2023version=(clickhouse_driver.__version__)print("ClickHouse Python version: ",version)ClickHousePythonversion:0.2.5
Checking your ClickHouse Version from PIP
To check your Python ClickHouse version installation from the terminal, enter:
How to install the ClickHouse Python terminal client on a Macintosh running Monterey using the Brew package installer, and connect to your Altinity.Cloud ClickHouse Cluster.
26 January 2023 · Read time 4 min
Overview - Macintosh ClickHouse Client
This section covers the installation and use of the Mac ClickHouse client.
After installation, you will be able to run ClickHouse queries from a Macintosh terminal.
The following ClickHouse install instructions using Brew is tested to work on Monterey (OS version 12.1)
This step checks the installed version of the ClickHouse macOS client.
You will note that it is not necessary to login to ClickHouse to run this command.
To check the installed ClickHouse version from a macOS terminal:
Enter the following string:
clickhouse client -q 'SELECT version()'22.7.2.1
Note that you are still in the macOS shell, not the ClickHouse interactive mode, as the following examples demonstrate.
Logging on to your ClickHouse cluster
To login to your cluster from the macOS terminal:
From the Connection Details, copy and paste the string of text into the macOS terminal:
Enter your ClickHouse cluster password at the prompt.
The ClickHouse version number is displayed, and the interactive prompt mode shows: example-cluster :)
ClickHouse client version 22.7.2.1.
Password for user (admin):
********
Connecting to example-cluster.your-cluster.altinity.cloud:9440 as user admin.
Connected to ClickHouse server version 22.3.15 revision 54455.
ClickHouse server version is older than ClickHouse client.
It may indicate that the server is out of date and can be upgraded.
example-cluster :)
Running ClickHouse Queries
To display all the tables in your cluster from a macOS terminal:
At the ClickHouse prompt, enter the query command show tables:
example-cluster :) show tables
SHOW TABLES
Query id: c04f8699-33db-4f4f-9a5b-e92fd25b6bb6
Password for user (admin):
Connecting to example-cluster.your-cluster.altinity.cloud:9440 as user admin.
Connected to ClickHouse server version 22.3.15 revision 54455.
ClickHouse server version is older than ClickHouse client.
It may indicate that the server is out of date and can be upgraded.
┌─name─────────┐
│ events │
│ events_local │
└──────────────┘
2 rows in set. Elapsed: 0.073 sec.
To display the data in the in your cluster table named events from a macOS terminal:
At the ClickHouse prompt, enter the query command select * from events:
example-cluster :)select * from events
SELECT *
FROM events
Query id: 998dbb3e-786e-404e-9d17-f044a6098191
Password for user (admin):
Connecting to example-cluster.your-cluster.altinity.cloud:9440 as user admin.
Connected to ClickHouse server version 22.3.15 revision 54455.
ClickHouse server version is older than ClickHouse client.
It may indicate that the server is out of date and can be upgraded.
┌─event_date─┬─event_type─┬─article_id─┬─title───┐
│ 2023-01-04 │ 1 │ 13 │ Example │
│ 2023-01-10 │ 1 │ 13 │ Example │
│ 2023-01-10 │ 1 │ 14 │ Example │
└────────────┴────────────┴────────────┴─────────┘
3 rows in set. Elapsed: 0.074 sec.
example-cluster :)
To quit, or exit from the ClickHouse interactive mode:
Enter the exit command to return to your macOS shell environment.
example-cluster :)exitBye.
This concludes the Quick Start instructions for how to install and use the Macintosh ClickHouse terminal client.
include:
collapses or expands 
the text labels beside the icons.
LAUNCH CLUSTER button.
List View icon.
displays the Query screen. This is where SQL queries are run on your cluster. Note the additional tabs for Schema, Workload and DBA Tools.
example-environment - Menu name changes to the selected environment (aka namespace or domain).
2/2 nodes online - Green to indicate running status. Action > Stop to take offline.
0/2 nodes online - Red shows nodes are not running. Action > Resume to start.
stopped - Cluster / node is not running. Action > Resume to start.
6/6 checks passed - Shows green when all 6 checks have completed successfully.
0/6 checks passed - Shows red until all checks have passed. Action > Resume to start.
Shield green - 
Actions - Mouse hover shows this light blue shade.
Blue outline - In cluster panel view, moving your mouse cursor over a cluster changes the grey outline to blue; click to view.
Panel view icon - View clusters in panel format.
List view icon - View cluster in a list format.
Address of all clusters - 
Address of a specific cluster - 
to view 
the password then copy and paste it to the Confirm Password field.
