Share and Share Alike

Captain Cloudsworth and Marina gather around your freshly stocked database. Youve created data. Youve 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 Creating Shares — publishing your database as a MotherDuck share.

Your 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. About share access levels:<ul><li>UNRESTRICTED — public, anyone on MotherDuck can attach</li><li>ORGANIZATION — visible only to members of your organization</li><li>RESTRICTED — 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! Replaying? <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

Database: https://dbquacks.com/data/databases/motherduck_tutorial.duckdb

This page as markdown: https://dbquacks.com/motherduck/11.md

Start level 11 →

DuckDB docs for this lesson