BigQuery sharing
BigQuery sharing is software for sharing data across organizations and letting subscribers access it without publishers creating separate copies.
What BigQuery sharing is
BigQuery sharing is software for sharing data across organizations and letting subscribers access it without publishers creating separate copies. A subscription creates a read-only linked dataset in the subscriber’s project. The service works with BigQuery datasets and Pub/Sub topics; publishers can create listings, manage subscriptions, and review listing usage metrics. Commercial listings can connect with Google Cloud Marketplace, and users can discover curated datasets from Google and other providers. BigQuery data clean rooms support partner collaboration without copying or moving the underlying data. Shared data has governance, encryption, and security controls from Cloud KMS, Cloud IAM, and VPC Service Controls. Listed compliance programs for BigQuery include ISO 27001, ISO 27017, ISO 27018, SOC 1, SOC 2, SOC 3, PCI, penetration testing, HIPAA, and HITRUST. It is available through API and web. Pricing is on request; managing exchanges or listings has no additional cost, while publishers pay storage and subscribers pay for queries.
Good
- Read-only linked datasets avoid duplicate copies.
- Supports both BigQuery datasets and Pub/Sub topics.
- Commercial listings can integrate with Google Cloud Marketplace.
- Clean rooms support partner collaboration without moving data.
Watch out
- A shared dataset is limited to 1,000 linked datasets.
- A shared topic is limited to 10,000 Pub/Sub subscriptions.
- Pricing is on request; publishers pay storage and subscribers pay for queries.
Who it suits
It suits organizations that need to share datasets or Pub/Sub topics with partners or internal teams. Publishers, subscribers, viewers, and administrators have roles described for managing access and collaboration.
Verdict
BigQuery sharing provides a structured way to publish and access data across organizational boundaries, including clean-room collaboration. Review the linked-dataset and subscription limits and clarify pricing before choosing it.
Plans and prices
From BigQuery sharing's own pricing page, checked 2 Oct 2001.
| Plan | Price | What it gives you |
|---|---|---|
| BigQuery sharing | Priced on request | No additional cost for managing data exchanges or listings · publishers pay storage · subscribers pay for queries |
The facts
Each one read from BigQuery sharing's own pages, with the date it was checked.
What it does
- Compliance
- Google lists ISO 27001, ISO 27017, ISO 27018, SOC 1, SOC 2, SOC 3, PCI, penetration testing, HIPAA, and HITRUST compliance programs for BigQuery sharing as part of BigQuery.checked 2 Oct 2001
- Data clean rooms
- Data clean rooms support partner collaboration in BigQuery without copying or moving the underlying data.checked 2 Oct 2001
- Dataset discovery
- BigQuery sharing provides access to curated datasets from Google and other data providers.checked 2 Oct 2001
- Intended users
- The documentation describes publisher, subscriber, viewer, and administrator roles for sharing data within an organization or with partners.checked 2 Oct 2001
- Marketplace integration
- Commercial listings can be integrated with Google Cloud Marketplace, where subscribers can browse and purchase them.checked 2 Oct 2001
- Pricing model
- There is no additional cost to manage exchanges or listings; dataset publishers pay storage and subscribers pay for queries, while Pub/Sub charges depend on throughput and applicable network egress.checked 2 Oct 2001
- Purpose
- BigQuery sharing lets organizations share, discover, and access data and insights across organizational boundaries.checked 2 Oct 2001
- Security controls
- Google says shared data includes governance, encryption, and security from Cloud KMS, Cloud IAM, and VPC Service Controls.checked 2 Oct 2001
- Sharing features
- Publishers can create listings, manage subscriptions, and view listing usage metrics.checked 2 Oct 2001
- Subscriber access
- Subscribing creates a read-only linked dataset in the subscriber’s project that points to the shared dataset.checked 2 Oct 2001
- Supported resources
- BigQuery sharing supports BigQuery datasets and Pub/Sub topics.checked 2 Oct 2001
- Usage limits
- A shared dataset can have at most 1,000 linked datasets, and a shared topic can have at most 10,000 Pub/Sub subscriptions.checked 2 Oct 2001
- Zero-copy sharing
- Publishers can share BigQuery datasets with subscribers without making multiple copies of the data.checked 2 Oct 2001
The company
- Founded
- 1998checked 28 Sep 2001
- Headquarters
- Mountain View, California, United Stateschecked 28 Sep 2001
Alternatives to BigQuery sharing
- 1
Snowflake CoCo
WebAPILinuxmacOS6.9 - 2
IQVIA SmartSolve Complaint Management
AndroidiOSWebAPI6.8 - 3
Advaneo DataMarketplace
Free planWebAPI6.7From €2,950 a month - 4
Datarade Marketplace
Free planWeb6.7From $50,001.67 a month - 5
Data Marketplace
Free planWebAPI6.6From $19 a month - 6
Informatica Product 360
WebAPISelf-hostedWindows6.5