Here’s a guide on exploring 120 years of global weather measurements with Clickhouse. I enjoyed following this guide over a weekend. Also it gives you a sense of the dataset, even if you’re not interested in the clickhouse part.
https://clickhouse.com/docs/en/getting-started/example-datas...