THE CLOUD EXPEDITION! · Chapter 5
The CSV Scrolls
Archivist Aria pushes her spectacles up with trembling excitement. I found historical records scattered across the web — raw CSV files, just sitting there on public servers! She cracks her knuckles over the keyboard. With httpfs, DuckDB can read them directly from any URL. No downloading, no importing — its basically telekinesis for data. Master HTTP File Reads — querying remote files directly by…
Your task
Use `read_csv()` to query the historical pond discoveries archive directly from its URL — no download needed. Filter for discoveries after 1950, ordered by year. File: `https://data.dbquacks.com/archives/pond_discoveries.csv` (remote CSV).<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. These files are hosted in US East.</div>