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)
| 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/7.md
All levels
- 1. Connect DuckDB to MotherDuck
- 2. Query a MotherDuck Table
- 3. MotherDuck Hybrid Queries
- 4. DESCRIBE a MotherDuck Table
- 5. Join Local and Cloud Tables
- 6. Aggregate Cloud Data in MotherDuck
- 7. ATTACH a MotherDuck Share
- 8. Query Several MotherDuck Shares
- 9. CREATE DATABASE in MotherDuck
- 10. Copy Data into a MotherDuck Table
- 11. CREATE SHARE in MotherDuck
- 12. DuckDB read_csv from a URL
- 13. DuckDB read_parquet from a URL
- 14. Join a Remote CSV with Cloud Tables
- 15. DuckLake Time Travel
- 16. Compare DuckLake Snapshots
- 17. DuckLake Time Travel with Shares
- 18. Aggregate 100 Million Rows in MotherDuck
- 19. EXPLAIN a MotherDuck Hybrid Query
- 20. Combine Local, Cloud and DuckLake Data
More: every SQL tutorial lesson · practice SQL exercises online