The Altinity Playground contains publicly accessible ClickHouse clusters running in Altinity Cloud with test datasets loaded. Use the links below to try them out:
Project Antalya is a branch of ClickHouse® code designed to integrate real-time analytic query with data lakes. This repository provides instructions on creating a stable build or Antalya environment in Altinity Cloud and loading the popular OnTime and Tripdata datasets like the public playground.
This demo covers the following steps:
- Creating an environment in Altinity Cloud using Terraform and AWS.
- Creating ClickHouse and swarm clusters in the Altinity Cloud ACM.
- Loading the OnTime and Tripdata datasets into MergeTree tables.
- Moving existing MergeTree data to S3 and creating Iceberg tables that ClickHouse can read.
- Creating Hybrid tables to query both MergeTree and Iceberg data as a single table.
The steps in this demo assume you have the following already:
- An AWS account
- An Altinity.cloud account. You can sign up for a trial account here.
The Altinity Cloud environment you will create is a ClickHouse environment that runs in your own AWS account that you can manage in the ACM (Altinity Cloud Manager) web UI. To create an environment, follow the Terraform steps.
After your environment is created, you can create a cluster from the clusters page in the ACM. Follow the docs for a detailed step-by-step on creating a ClickHouse cluster. When selecting a ClickHouse version, select the Altinity Antalya build for Antalya features (swarms, Iceberg tables). If you want to create stable build playground, select the latest Altinity Stable build instead.
If using Analya, follow the steps to create an Iceberg catalog and optionally set up a swarm cluster.
The OnTime dataset has records of airline on-time performance of domestic US flights from 1987 to 2025. Tables in the public playground include:
- ontime.fact_ontime (main flight data)
- ontime.dim_airports (dimension table for active airports)
- ontime.dim_airports_bts_full (dimension table for all historical airports)
There are docs for loading two different versions of the data:
- OnTime V2 (with dimension tables) - Used by the public playground
- OnTime V1 - Single ontime.ontime table
The Tripdata dataset contains records of taxi and for-hire vehicle rides in New York City from 2009 to 2025. Tables in the public playground include:
- tripdata.fhv_trips (trips from for-hire vehicles/rideshare starting in 2015)
- tripdata.taxi_trips (trips for yellow and green cabs)
- tripdata.taxi_zones (dimension table for taxi zone codes)
To load the dataset, read the Tripdata docs.
- Join the AltinityDB Slack Workspace to ask questions.
- Log an issue on Antalya code.
Altinity is the primary maintainer of Project Antalya. It is the basis of our data lake-enabled Altinity.Cloud and is also used in self-managed installations. Altinity offers a range of services related to ClickHouse® and data lakes.
- Official website - Get a high level overview of Altinity and our offerings.
- Altinity.Cloud - Run Antalya in your cloud or ours.
- Altinity Support - Get Enterprise-class support for ClickHouse®.
- Slack - Talk directly with ClickHouse® users and Altinity devs.
- Contact us - Contact Altinity with your questions or issues.
- Free consultation - Get a free consultation with a ClickHouse® expert today.
Altinity maintains and supports Project Antalya. Altinity is not affiliated or associated with ClickHouse Inc any way. ClickHouse® is a registered trademark of ClickHouse, Inc.