Sharing data with your organization

MotherDuck makes it easy for you to share data with all members of your Organization and making that data easily discoverable and queryable. This is a common use case for small, highly collaborative data teams.

1. Data provider creates an Organization scoped, Discoverable share.
2. Data consumers easily find the share and attach it.
3. Data provider periodically updates the share to push new data to data consumers.

1. Creating organization-scoped, discoverable shares

To share a database with your Organization, create a share. No actual data is copied and no additional costs are incurred in this process.

UI

Click on the "trident" next to the database you'd like to share. Select "share". Then:

1. Optionally, choose a share name. Default will be the database name.
2. Choose whether the share should only be accessible by users in your Organization, or anyone with the share link.
3. Choose whether the share should be automatically updated or not. Default is MANUAL

SQL

use birds;
CREATE SHARE; -- Shorthand syntax. Share name is optional. By default, shares are Organization-scoped and Discoverable. 
CREATE SHARE birds FROM birds
    (ACCESS ORGANIZATION , VISIBILITY DISCOVERABLE); -- This query is identical to the previous one yet optionally more verbose. 

2. Finding and consuming shares

The data consumer in your Organization can use the UI to find the share, attach it, and start querying it!

UI

1. Select the share you want under "Shared with me"
2. Click "attach" and optionally name the resulting database.
3. You can now query the resulting database.

note

The ability to list and discover Discoverable shares in SQL is coming shortly.

3. Updating shared data

If the database being shared has changed, in order for the changes to propagate to the data consumer, the data provider needs to update the share.

UPDATE SHARE birds; 

Learn more about UPDATE SHARE.

note

We are working on auto-updating shares.