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:

1. From the main menu, select Database->New Database Connection.
2. From the Select your database screen, select ClickHouse.
3. Set the following options:
   1. Tab *Main:
      1. JDBC URL: jdbc:clickhouse://github.demo.altinity.cloud:8443/default (DBeaver populates this by default based on the other settings).
      2. Host: github.demo.altinity.cloud
      3. Port: 8443
      4. Database/Schema: default
      5. Username: demo
      6. Password: demo
   2. Tab Driver Properties:
      1. ssl: true
4. 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

• Everything You Always Wanted To Know About GitHub (But Were Afraid To Ask)
• GitHub Events Dataset

datatype_test

The datatype_test table is a small table for testing datatypes, and does not current play into current demonstrations.