THE CLOUD EXPEDITION! · Chapter 4
Stock the Pond
Marina swims up with an armload of data scrolls. An empty database is like an empty pond — no fun at all! She winks. Lucky for you, my lakes species data is publicly shared. Lets copy it into YOUR database and make it your own. Learn to Populate a Database — copying data from a public share into your own cloud database.
Your task
Copy Marina Lake's species data into your own database, then verify the results. First create a table in your database using <code>CREATE OR REPLACE TABLE ... AS SELECT</code>, then query the top 5 species by population. Run both statements together.<br><br><b>Re-attach if needed:</b><ul><li><code>dbquacks_marina_lake</code> → <code>md:_share/marina_lake_db/3be07852-dfce-4b29-b415-99c9f7fdcc6a</code></li></ul>
Hint
Use CREATE OR REPLACE TABLE ... AS SELECT to copy data into your new database
Expected result
5 rows with columns: species_name, population_count from your own database's my_species table
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_marina_lake.species
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/10.md