🗄️Data Partitioning
Also known as Table Partitioning, Partitioned Table, Partition Key
A big table cut into parts by one column. Most often that column is a date.
Think of it like
It is like a filing box with one drawer per month. To find May, you open just the May drawer.
Example
An events table holds three years of clicks, split by day. A report on last week reads 7 folders, not 1,095.
Why it matters
It is the cheapest way to make big tables fast. It also makes deleting old data easy.
Definition
Example code
console
$ ls events/
date=2026-11-14/ date=2026-11-15/ date=2026-11-16/Common mistake
Key takeaways
- 1Split by a column. Most often a date.
- 2Read fewer parts. Filters skip whole parts.
- 3Not too many. Tiny parts are slow.