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:
- URL:
github.demo.altinity.cloud
- HTTP Protocol:
HTTPS
- HTTPS Port:
8443
- ClickHouse Client Port:
9440
- Database:
default
- Username:
demo
- Password:
demo
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.
ClickHouse Client
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
):
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). - Host:
github.demo.altinity.cloud
- Port:
8443
- Database/Schema:
default
- Username:
demo
- Password:
demo
- JDBC URL:
- Tab Driver Properties:
- ssl:
true
- ssl:
- Tab *Main:
- Select Finish.
Grafana
For Grafana, see the Integrating Grafana with ClickHouse guide.
Altinity.Cloud Tables
The following tables are part of the Altinity.Cloud Demo database.
ontime
The table ontime
is provided from the Bureau of Transportation Statistics.
The 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
The table 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 ontime
table.
The information in this table is provided by OpenFlights.org, from their Airport database.
tripdata
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
The table 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.
References
datatype_test
The datatype_test
table is a small table for testing datatypes, and does not current play into current demonstrations.