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 its yours to query. Welcome to Attaching Shared Data — using ATTACH to connect public shared databases to your session. Public shares are…
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>