THE CLOUD EXPEDITION! · Chapter 5
Parquet-ly Cloudy
Arias eyes go wide behind her spectacles. Forget CSV — Parquet is the FORMAT OF LEGENDS. Columnar storage, built-in compression, blazing-fast scans. She fans herself with a schema diagram. DuckDB devours Parquet files straight from cloud storage — point it at a URL and it reads only the columns you ask for. Time to discover Parquet Files — reading columnar data directly from cloud storage.
Your task
Use `read_parquet()` to read the 2025 regional census archive and summarize total population by region. Return <b>region</b> and <b>total_population</b>, most populated regions first. File: `https://data.dbquacks.com/archives/census_2025.parquet` (public Parquet). Columns include `region` and `population`.<br><br><div class="text-xs text-gray-400 mt-2">Regional tip: MotherDuck runs in US East, US West, and EU Central. For best performance, query data stored in your region. This file is hosted in US East.</div>