ClickHouse v25.8 introduces significant improvements to its JSON data handling, enhancing performance for analytics over JSON data. The update builds on the JSON data type introduced in v24.8, addressing inefficiencies when dealing with large numbers of unique JSON paths. Two new serialization formats, bucketed shared data and advanced shared data, aim to improve query performance by efficiently managing how JSON paths are stored and accessed. The bucketed format divides shared data into manageable buckets, while the advanced format uses a complex structure to allow selective reads of JSON subcolumns without unnecessary data loading. Although these formats enhance performance, especially for selective reads, they necessitate a trade-off with increased storage requirements due to the need to store data in both the new and original formats. Benchmark tests demonstrate substantial gains in query speed and memory usage, particularly for datasets with tens of thousands of unique paths, making ClickHouse a more robust choice for handling large-scale JSON data.