📝 Unsaved Draft · the spreadsheet-native ClickHouse · a project of the SNCF
A columnar OLAP engine — spreadsheets are already columnar.
Columns are the native storage; GROUP BY and aggregations run via QUERY() and pivot tables (OLAP cubes for free). Materialized views are tabs recomputed by a trigger; partitions are sheets by date. Columnar analytics, spreadsheet-native.
Aggregations via QUERY() + pivot tables = OLAP cubes.
A tab recomputed on a trigger.
Sheets by date.
| Sheethouse 💩 | ClickHouse | |
|---|---|---|
| Storage | Columnar | Columnar |
| Scale | ~10M cells | Billions of rows |
| Aggregation speed | Slow | Blazing |
| Spreadsheet-native | ✅ | ❌ |