THE CLOUD EXPEDITION! · Chapter 4
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.<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.