Services

Resources

Company

Our Work

Blog

Schedule a Meet

Amit Sadafule

Lead Software Engineer

Portrait of Amit Sadafule, Lead Software Engineer

Amit has a soft spot for databases that stay honest under odd data shapes. Schema choices you will not regret at 2 a.m. are his idea of a good time.

Blogs published by Amit Sadafule.

Blogs published by Amit Sadafule.

Cover illustration for ClickHouse schema optimization for sparse data sets

Read Blog

ClickHouse schema optimization for sparse data sets

Portrait of Amit Sadafule, Lead Software Engineer

Amit Sadafule

Lead Software Engineer

Portrait of Spandan Ghosh, Content at One2N

Spandan Ghosh

Content @One2N

Portrait of Saurabh Hirani, Principal SRE at One2N

Saurabh Hirani

Principal SRE @One2N

Portrait of Chinmay Naik, CEO at One2N

Chinmay Naik

CEO @One2N

Schema designs for storing and querying sparse data sets in ClickHouse, including a sparse matrix and separate tables, and when each one fits.

September 19, 2024 | 10 min read

All Authors