ClickHouse Schema Design

ALWAYS LOAD when creating or modifying ClickHouse tables.

Goals

• Sub-second query response on billion-row tables
• 10x+ compression ratios vs raw data
• Zero-maintenance data retention and tiered storage
• Queries that scan <1% of data instead of full table scans

Reference Documentation

• MergeTree Engine
• Primary Keys and Indexes
• Data Types
• TTL
• Altinity: Pick Keys Guide