THE CLOUD EXPEDITION! · Chapter 3

Open Sesame Data

Marina drags you toward a glowing doorway. 'Behind here? Public shares — datasets that owners have published for open access, live, queryable, no downloads!' She pulls out a golden key. 'But first, you need to ATTACH the database to your session. One command, and it's yours to query.' Welcome to Attaching Shared Data — using ATTACH to connect public shared databases to your session. Public shares…

Your task

Attach Marina Lake's shared database, then query its species. First run <code>ATTACH IF NOT EXISTS</code> to connect the database, then query the top 10 most populous species showing <b>species_name</b>, <b>population_count</b>, and <b>habitat_preference</b>. Run both statements together — the result from the final SELECT is what gets validated.<br><br>These are <b>public shares</b> — open datasets any MotherDuck user in the same region can attach. No special permissions needed.<br><br><b>Share URL:</b><ul><li><code>dbquacks_marina_lake</code> → <code>md:_share/marina_lake_db/3be07852-dfce-4b29-b415-99c9f7fdcc6a</code></li></ul>

Hint

Use ATTACH IF NOT EXISTS with the share URL and an alias to connect to a shared database

Expected result

10 rows with columns: species_name, population_count, habitat_preference from Marina Lake's shared database

Tables

lake_visits (500 rows)

columntype
visit_idBIGINT
duck_idBIGINT
destination_pondVARCHAR
visit_dateDATE
purposeVARCHAR

pondville_events (50 rows)

columntype
event_idBIGINT
event_nameVARCHAR
event_dateDATE
organizer_idBIGINT
locationVARCHAR
attendee_countBIGINT

pondville_residents (100 rows)

columntype
duck_idBIGINT
nameVARCHAR
speciesVARCHAR
home_pondVARCHAR
ageBIGINT
occupationVARCHAR
joined_dateDATE

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/7.md

Start level 7 →

DuckDB docs for this lesson

All levels

  1. 1. Connect DuckDB to MotherDuck
  2. 2. Query a MotherDuck Table
  3. 3. MotherDuck Hybrid Queries
  4. 4. DESCRIBE a MotherDuck Table
  5. 5. Join Local and Cloud Tables
  6. 6. Aggregate Cloud Data in MotherDuck
  7. 7. ATTACH a MotherDuck Share
  8. 8. Query Several MotherDuck Shares
  9. 9. CREATE DATABASE in MotherDuck
  10. 10. Copy Data into a MotherDuck Table
  11. 11. CREATE SHARE in MotherDuck
  12. 12. DuckDB read_csv from a URL
  13. 13. DuckDB read_parquet from a URL
  14. 14. Join a Remote CSV with Cloud Tables
  15. 15. DuckLake Time Travel
  16. 16. Compare DuckLake Snapshots
  17. 17. DuckLake Time Travel with Shares
  18. 18. Aggregate 100 Million Rows in MotherDuck
  19. 19. EXPLAIN a MotherDuck Hybrid Query
  20. 20. Combine Local, Cloud and DuckLake Data

More: every SQL tutorial lesson · practice SQL exercises online