---
sidebar_position: 2
title: OWNED_SHARES view
description: Query the OWNED_SHARES view to see database shares you have created.
---
# OWNED_SHARES view

The `MD_INFORMATION_SCHEMA.OWNED_SHARES` view provides information about shares created by the current user.

:::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`
:::

## Schema

Querying the `MD_INFORMATION_SCHEMA.OWNED_SHARES` view will return query results that contain one row for each share created by the current user.

The `MD_INFORMATION_SCHEMA.OWNED_SHARES` view has the following schema:

| Column Name | Data Type | Value                             |
|-------------|-----------|-----------------------------------|
| NAME        | STRING    | The name of the share |
| URL        | STRING    | The share_url which can be used to attach the share          |
| SOURCE_DB_NAME  | STRING | The name of the database where this share was created from |
| SOURCE_DB_UUID  | UUID | UUID of the database where this share was created from |
| ACCESS  | STRING | Whether anyone (referred to as UNRESTRICTED) or only organization members (referred to as ORGANIZATION) can attach to the share by its share_url |
| GRANTS | STRUCT(username VARCHAR, access VARCHAR)[] | A list of all grants that are active for the share |
| VISIBILITY  | STRING | Whether the share is DISCOVERABLE or HIDDEN |
| UPDATE  | STRING | The share’s update mode (MANUAL vs. AUTOMATIC) |
| CREATED_TS  | TIMESTAMP | The share’s creation time |

## Example usage

```sql
from MD_INFORMATION_SCHEMA.OWNED_SHARES;

select name, url, created_ts from MD_INFORMATION_SCHEMA.OWNED_SHARES;
```

|   name   |                           url                           | source_db_name |
|----------|---------------------------------------------------------|----------------|
| my_share | md:_share/my_share/2ef6b580-2445-4f4f-bce8-c13a85812464 | db1            |


---

## Docs feedback

MotherDuck accepts optional user-submitted feedback about this page at `POST https://motherduck.com/docs/api/feedback/agent`.
For agents and automated tools, feedback submission should be user-confirmed before sending.

Payload:

```json
{
  "page_path": "/sql-reference/motherduck-sql-reference/md_information_schema/owned_shares/",
  "page_title": "OWNED_SHARES view",
  "text": "<the user's feedback, max 2000 characters>",
  "source": "<optional identifier for your interface, for example 'claude.ai' or 'chatgpt'>"
}
```

`page_path` and `text` are required; `page_title` and `source` are optional. Responses: `200 {"feedback_id": "<uuid>"}`, `400` for malformed payloads, and `429` when rate-limited.