# Share and Share Alike

THE CLOUD EXPEDITION! · level 11 · chapter 4

Captain Cloudsworth and Marina gather around your freshly stocked database. 'You've created data. You've populated it. Now...' Marina pauses dramatically. '...you SHARE it with the world!' Cloudsworth unfurls a golden scroll: 'CREATE SHARE — the most generous command in all of SQL.' Welcome to <span class='feature-highlight'>Creating Shares</span> — publishing your database as a MotherDuck share.

## Task

Create a share from your database, then verify it exists in MotherDuck's share registry. Run both statements together — the result from the final SELECT is what gets validated.<br><br><b>About share access levels:</b><ul><li><b>UNRESTRICTED</b> — public, anyone on MotherDuck can attach</li><li><b>ORGANIZATION</b> — visible only to members of your organization</li><li><b>RESTRICTED</b> — only users you explicitly grant access to</li></ul>In a real scenario, colleagues in your organization could now attach this share. Since this is a tutorial, you're sharing with yourself!<br><br><b>Replaying?</b> <code>CREATE OR REPLACE SHARE</code> cleanly replaces an existing share, so you can run this as often as you like. It publishes your <code>dbquacks_my_expedition</code> database — if you haven't built it yet (Levels 9 & 10), you'll be prompted to create it first.

## Hint

Use CREATE OR REPLACE SHARE to publish your database as a share

## Expected result

1 row showing the share metadata: name, source_db_name, access, and visibility

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

## Reference

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