THE CLOUD EXPEDITION! · Chapter 6
Quack to the Future
A shimmering lake pulses with light. An ancient duck materializes from the mist — Chronos the Timekeeper. Every change leaves a shadow, he intones. Ducklake remembers what others forget. Step into the past... if you dare. Welcome to Time Travel — querying historical snapshots of a Ducklake table.
Your task
Look back in time to the pre-storm census. Query the original snapshot (version 1) of the pond census, returning all columns ordered by population descending. Use the `AT (VERSION => 1)` syntax after the table name. Table: `dbquacks_living_lake.pond_census` (Ducklake).
Hint
Add AT (VERSION => 1) after the table name to query a historical snapshot
Expected result
All rows from the pre-storm census (version 1) with columns like district, population, and water_level ordered by population descending
Tables
lake_visits (500 rows)
| column | type |
|---|---|
visit_id | BIGINT |
duck_id | BIGINT |
destination_pond | VARCHAR |
visit_date | DATE |
purpose | VARCHAR |
pondville_events (50 rows)
| column | type |
|---|---|
event_id | BIGINT |
event_name | VARCHAR |
event_date | DATE |
organizer_id | BIGINT |
location | VARCHAR |
attendee_count | BIGINT |
pondville_residents (100 rows)
| column | type |
|---|---|
duck_id | BIGINT |
name | VARCHAR |
species | VARCHAR |
home_pond | VARCHAR |
age | BIGINT |
occupation | VARCHAR |
joined_date | DATE |
dbquacks_living_lake.pond_census
A table in a MotherDuck share; its columns are not listed here.
Database: https://dbquacks.com/data/databases/motherduck_tutorial.duckdb
This page as markdown: https://dbquacks.com/motherduck/15.md