THE CLOUD EXPEDITION! · Chapter 1
First Contact
Captain Cloudsworth unfurls a tattered scroll with a flourish. Behold — the global registry! Ponds from every corner of the world, all stored in the cloud. He taps the scroll dramatically. Lets see whats out there... Time to run your first Cloud Query — selecting data directly from a MotherDuck table.
Your task
Preview 10 rows from the global pond registry to see what data is available. Table: `dbquacks_cloud_expedition.global_ponds` (MotherDuck).
Hint
Use SELECT with LIMIT to preview rows without loading the entire table. Remember to use the fully qualified table name with the database prefix
Expected result
10 rows from global_ponds showing columns like pond_name, region, and climate_zone
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_cloud_expedition.global_ponds
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/2.md