- Course
Model Data in ClickHouse
Analytical tables need a design that fits the questions asked of them. This course will teach you to design a ClickHouse schema, choose a sorting key and partitioning, and build a validated table with the right MergeTree engine.
Intermediate
- Course
Model Data in ClickHouse
Analytical tables need a design that fits the questions asked of them. This course will teach you to design a ClickHouse schema, choose a sorting key and partitioning, and build a validated table with the right MergeTree engine.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
A table that simply mirrors a CSV file can make every report slow and some answers wrong.
In this course, Model Data in ClickHouse, you’ll gain the ability to design ClickHouse tables that answer analytical questions quickly and correctly.
First, you’ll explore how to turn a workload into a table grain and ClickHouse data types.
Next, you’ll discover how the sorting key decides what a query reads and when partitioning helps.
Finally, you’ll learn how to choose a MergeTree engine, migrate the data, query deduplicated rows, and validate the results.
When you’re finished with this course, you’ll have the skills and knowledge of ClickHouse data modeling needed to build a typed table, query its latest versions correctly, and validate its answers, speed, and storage.
Model Data in ClickHouse
Intermediate
Table of contents
Pinal Dave is a Pluralsight Developer Evangelist.
