THE CLOUD EXPEDITION! · Chapter 4
A Room of One's Own
Captain Cloudsworth puffs his chest and points to the sky. Youve explored others data long enough — time to build YOUR OWN research station in the cloud! He pulls out a blueprint scroll with MY EXPEDITION scrawled across it. One command and youll have a real database, living in your MotherDuck account. Time to master Database Creation — creating your own cloud database on MotherDuck.
Your task
Create your own cloud database and verify it exists. Run <code>CREATE OR REPLACE DATABASE</code> to set up your research station, then <code>SHOW DATABASES</code> to confirm it's live. Run both statements together — the result from the final statement is what gets validated.<br><br><b>Note:</b> This creates a real database in YOUR MotherDuck account. <code>CREATE OR REPLACE</code> gives you a clean start on replay — though if you've already published a share from it in a later level, you'll be prompted to drop that share first, since MotherDuck won't replace a database a share points at.
Hint
Use CREATE OR REPLACE DATABASE to create your own cloud database
Expected result
A list of databases attached to your session, including dbquacks_my_expedition
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 |
Database: https://dbquacks.com/data/databases/motherduck_tutorial.duckdb
This page as markdown: https://dbquacks.com/motherduck/9.md