# A Room of One's Own

THE CLOUD EXPEDITION! · level 9 · chapter 4

Captain Cloudsworth puffs his chest and points to the sky. 'You've 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 you'll have a real database, living in your MotherDuck account.' Time to master <span class='feature-highlight'>Database Creation</span> — creating your own cloud database on MotherDuck.

## 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 |

## Data

The tables live in a DuckDB database: https://dbquacks.com/data/databases/motherduck_tutorial.duckdb

To query it outside the browser, attach it read-only:

```sql
ATTACH 'https://dbquacks.com/data/databases/motherduck_tutorial.duckdb' AS db (READ_ONLY);
USE db;
```

This level also queries MotherDuck shares, which need a MotherDuck token. On the page, the editor asks for one.

Play it in the browser: https://dbquacks.com/motherduck/9

## Reference

https://motherduck.com/docs/sql-reference/motherduck-sql-reference/create-database/