BigQuery sharing is a service for exchanging data and insights between organizations, including publishers, subscribers, viewers, and administrators. Publishers can offer BigQuery datasets without creating separate copies, and subscribers receive a read-only linked dataset in their own project. It also supports Pub/Sub topics, listing management, subscription controls, and usage metrics. Commercial listings can be offered through Google Cloud Marketplace, alongside curated datasets from Google and other providers. For partner work, data clean rooms support collaboration without moving or duplicating the underlying data. Google says shared data uses governance, encryption, and controls from Cloud KMS, Cloud IAM, and VPC Service Controls, and lists compliance programs for BigQuery. A shared dataset can have up to 1,000 linked datasets; a shared topic can have up to 10,000 subscriptions. API and web access are available. Pricing is on request; managing exchanges or listings has no additional cost, while publishers pay for storage and subscribers pay for queries.
Who it is for
It suits organizations that need to publish or consume datasets and Pub/Sub topics across teams or with partners. Publishers can manage listings and subscriptions, while subscribers query read-only linked datasets.
What is good
- Shares datasets without making subscriber copies
- Supports both BigQuery datasets and Pub/Sub topics
- Includes Marketplace listings and curated datasets
- Clean rooms support partner collaboration without data movement
- Offers governance and access controls named by Google
What to know first
- Shared datasets are limited to 1,000 linked datasets
- Shared topics are limited to 10,000 subscriptions
- Pricing is available on request
Verdict
BigQuery sharing is suited to organizations exchanging data through controlled listings and read-only linked datasets. Keep the linked-dataset and subscription limits, as well as storage and query charges, in view when assessing fit.
BigQuery sharing plans and pricing
All plansCompared on data marketplace software
- Data transactions
- Yes
- Seller publishing
- Yes
- Access controls
- Yes
- Delivery methods
- query
- Private marketplace
- Yes
- Commercial model
- custom
