Date: July 9, 2026
Time: 11:30AM SGT
Duration: 3 hours
Location: Virtual - Zoom Webinar
Cost: FREE
Format: Instructor-led training with hands-on labs
What you’ll learn: In this hands-on training, learners will understand how to customize their ClickStack deployment to make the most out of it. You'll learn about ClickHouse internals and how to customize primary keys, partitions, and schema. You'll also learn how to do schema on read and write with ClickHouse and how to use advanced techniques, such as materialized views and skipping indexes, to improve query performance. Finally, you'll learn how to set up alerts. After completing each module and passing the accompanying quizzes, you’ll become a ClickHouse Observability Professional!
By the end of this session you'll be able to:
- Define custom Primary Keys
- Define custom Partitions
- Customize ClickStack Schema
- Use Maps and JSON datatypes
- Materialize columns out of Maps and Jsons
- Define a TTL
- Customize column codecs
- Set up materialized views for enrichment
- Set up materialized views for roll-ups
- Optimize queries with skipping indexes
There will be both instructor-led training and hands-on labs. The material is presented in modules and will include:
Module 4: ClickHouse Architecture
Module 5: Schema Design
Module 6: Query Acceleration Techniques
Module 7: Alerting
Pre-requisites:
- It is recommended that you have already completed the Observability with ClickStack: Level 1 training
- During the training, you will access your course materials in ClickHouse Academy. It is recommended that you create an account before the event HERE.
- ClickHouse Cloud account to access the labs
- You will also need to spin up a ClickHouse Cloud Service. If you have already used up your free trial, please contact us at least one day before the training.
- Familiarity with terminals and containers is helpful
- Docker or equivalent
- Have permission to bind Docker to localhost on ports 8000, 8001, 8080, 4317, 4318
Note: This is the 2nd training of the three-part Observability with ClickStack Training series. If you are interested in continuing your journey to becoming a ClickHouse expert and gaining the hands-on expertise needed to become a Certified ClickHouse Engineer, please register for on-demand training using the link below: Observability with ClickStack: Level 3
