Altinity.Cloud Demo Cluster
To help new users to experience ClickHouse, and assist experience ClickHouse administrators test connections between applications and ClickHouse, Altinity has created several guides in both the Integrations section of the Altinity Documentation site, and various blog posts posted in the Altinity Resources Page.
As part of these guides, Altinity has created a public ClickHouse database hosted through Altinity.Cloud. This allows users to test business intelligence applications, understand how to construct SQL queries in a way that maximizes on the ClickHouse column based architecture, and use the understand in developing their own ClickHouse based applications and services.
The following details the connection details for the Altinity.Cloud demo ClickHouse database, and some examples of connecting to it.
Altinity.Cloud Demo Database Details
The Altinity.Cloud Demo database has the following connection information:
- HTTP Protocol:
- HTTPS Port:
- ClickHouse Client Port:
Altinity.Cloud Demo Database Connection Examples
The following examples provide a quick demonstration on how to connect specific interfaces and applications to the Altinity.Cloud Demo database. For more information on creating a trial Altinity.Cloud environment for your organizations use, see the Altinity.Cloud trial registration page.
To connect to the Altinity.Cloud Demo database with the native ClickHouse client, use the following command (note that for operating systems such as OS X, use
clickhouse client instead of
clickhouse-client --host github.demo.altinity.cloud --user=demo --password=demo --port=9440 --secure
DBeaver and JDBC Connectors
For applications like Dbeaver that use JDBC drivers to connect to database, use the following settings:
- From the main menu, select Database->New Database Connection.
- From the Select your database screen, select ClickHouse.
- Set the following options:
- Tab *Main:
- JDBC URL:
jdbc:clickhouse://github.demo.altinity.cloud:8443/default(DBeaver populates this by default based on the other settings).
- JDBC URL:
- Tab Driver Properties:
- Tab *Main:
- Select Finish.
For Grafana, see the Integrating Grafana with ClickHouse guide.
The following tables are part of the Altinity.Cloud Demo database.
ontime is provided from the Bureau of Transportation Statistics.
ontime table is collected from Airline On-Time Performance Data. This information is based on flight data collected by US certified air carriers regarding departure and arrival times, flights cancelled, flights with delayed departure or arrival times, and other relevant data.
airports is information on airports including the name of the airport, city, latitude and longitude, and other relevant information. For the Altinity.Cloud Demo database, this is often joined with the
tripdata table is based on the New York City Taxi & Limousine Commission (TLC) Trip Record Data Yellow Cab ride data. This table contains information about rides starting and ending in New York City, the data and time of pickups and dropoffs, the total amount of the fair, and other data. This was used as part of the article Tableau Tricks with ClickHouse.
github_events is a collection of all Github events between 2011 to 2020, comprising 3.1 billion records and 200 GB of data. This is provided from GH Archive.
datatype_test table is a small table for testing datatypes, and does not current play into current demonstrations.