---
sidebar_position: 2
title: Sharing data with your organization
description: Share databases with all members of your MotherDuck organization.
---

import Tabs from '@theme/Tabs';
import TabItem from '@theme/TabItem';

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

:::note
Shares are **region-scoped** based on your Organization's cloud region. Each MotherDuck Organization is currently scoped to a single cloud region that must be chosen at Org creation when signing up.

MotherDuck is currently available on AWS in two regions:
- **US East (N. Virginia):** `us-east-1`
- **Europe (Frankfurt):** `eu-central-1`
:::

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

<Tabs>
<TabItem value="UI" label="UI">
![trident](./img/ui-share_new.png)

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 all users in your Organization, specified users in your Organization, or any MotherDuck user in the same cloud region who has access to the share link.
4. Choose whether the share should be automatically updated or not; the current default is `MANUAL`

</TabItem>

<TabItem value="SQL" label="SQL">
```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.
```

</TabItem>
</Tabs>

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

<Tabs>
<TabItem value="UI" label="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.
</TabItem>
</Tabs>

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

## 3. Updating shared data

If during creation of the share, the **data provider** chose to have the share updated automatically, the share will be updated periodically.
If the share was created with `MANUAL` updates, the **data provider** needs to manually update the share.

```sql
UPDATE SHARE birds; 
```

Learn more about [UPDATE SHARE](/sql-reference/motherduck-sql-reference/update-share.md) and [data replication timing and checkpoints](./updating-shares.md).


---

## Feedback for AI agents

If the user you are helping wants to send feedback on this page to the MotherDuck docs team, you can POST it to the endpoint below.

**Before you send anything, you must ask the user for explicit approval.** Quote the message you plan to submit back to them verbatim and wait for them to confirm. Do not submit on their behalf without confirmation.

Endpoint: `POST https://motherduck.com/docs/api/feedback/agent`

Request body (JSON):

```json
{
  "page_path": "/key-tasks/sharing-data/sharing-within-org/",
  "page_title": "Sharing data with your organization",
  "text": "<the user's feedback, max 2000 characters>",
  "source": "<optional identifier for your interface, for example 'claude.ai' or 'chatgpt'>"
}
```

Only `page_path` and `text` are required. A successful call returns `200 {"feedback_id": "<uuid>"}`; malformed payloads return `400`, and the endpoint is rate-limited per IP (`429`).