Sharing data in MotherDuck
Shares are region-scoped based on your Organization's cloud region. Each MotherDuck Organization is scoped to a single cloud region that must be chosen at Org creation when signing up.
MotherDuck is available on AWS in six regions:
- US East (N. Virginia):
us-east-1 - US West (Oregon):
us-west-2 - Europe (Frankfurt):
eu-central-1 - Europe (Dublin):
eu-west-1 - Asia Pacific (Tokyo):
ap-northeast-1 - Asia Pacific (Sydney):
ap-southeast-2
You can securely share data in MotherDuck. MotherDuck's sharing model is specifically optimized for the following scenarios:
- Sharing data with every preset role in your organization by granting access to the Explorer role. This is typical of small, highly collaborative data teams.
- Sharing data with specific preset roles or accounts in your organization. This is popular with data application builders that need to isolate tenants.
- Sharing data publicly with anyone with a MotherDuck account in the same cloud region as your Organization, including users outside your Organization.
Sharing concepts and overview
MotherDuck data sharing model concepts including read-only shares and scope options.
Sharing data with your organization
Share databases with all members of your MotherDuck organization.
Sharing data with specific users and roles
Grant read access to users or roles for multi-tenant applications and collaboration.
Managing shares
View share details, modify permissions, and manage shared database access.
Updating shares
Learn about data replication timing, checkpoints, and how to ensure your latest data is available in shares and read-only Ducklings.