BigQuery Data Clean Rooms
cloud.google.com
- Web
- API
What BigQuery Data Clean Rooms is
BigQuery Data Clean Rooms let multiple parties share, join, and analyze data without moving or exposing the underlying data. The cloud service works with BigQuery sharing, and each shared resource must be a BigQuery table, view, or table-valued function. Owners manage rooms, contributors publish data, and subscribers query it. Contributors can configure analysis rules, including aggregation thresholds, and provide query templates so subscribers can run predefined queries without seeing underlying tables or views. The service blocks subscribers from copying or exporting raw data, while contributors can also set controls for query results. Google warns that analysis rules may not stop sophisticated queries from extracting unauthorized data and recommends templates for approved-query control. A room can hold up to 100 shared resources; availability is limited to BigQuery sharing regions, with no listings across multiple regions. Setup requires enabling the Analytics Hub API and assigning required IAM roles. Contributors pay for storage, while subscribers pay for compute when queries run. Rooms can be managed in the Google Cloud console or created through the API.
Who it suits
It suits organizations that need to publish and analyze shared data while applying query and output controls. Contributors and subscribers should account for separate storage and compute charges and the stated privacy limits.
Good to know, and what to watch
- Supports aggregation thresholds and predefined query templates.
- Prevents subscribers from copying or exporting raw data.
- Provides separate contributor and subscriber roles.
- Can be managed in the console or created through the API.
- Analysis rules may not stop sophisticated data-extraction queries.
- Rooms are limited to 100 shared resources.
- Available only in BigQuery sharing regions.
Plans
Every plan and priceData contributor
Data clean room subscriber
Free plan
Getting started
- Open the BigQuery Data Clean Rooms documentation
- Enable the Analytics Hub API
- Assign the required IAM roles, including Analytics Hub Admin for owners
- Create a clean room through the API or manage it in the Google Cloud console
- Add BigQuery tables, views, or table-valued functions as shared resources
- Assign owner, contributor, and subscriber roles
Limits to check
A clean room can contain no more than 100 shared resources. Analysis rules work only on views, and Google warns they may not stop sophisticated queries from extracting unauthorized data.
The verdict
BigQuery Data Clean Rooms provide controls for sharing and querying data without exposing raw tables. The privacy caveat and regional and resource limits matter when planning a deployment.
Questions people ask
What does BigQuery Data Clean Rooms cost?
The service has a free plan. Contributors are charged for data storage, while subscribers are charged for compute when they run queries.
Which platforms are supported?
BigQuery Data Clean Rooms supports web and API access and runs as a cloud deployment.
What can be shared?
Shared resources must be BigQuery tables, views, or table-valued functions.
How are query results controlled?
Contributors can configure analysis rules and controls for query results. Query templates can provide predefined queries without exposing underlying tables or views.
What roles are available?
The product defines owner, contributor, and subscriber roles for managing rooms, publishing data, and querying shared data.
What the maker publishes
- Access setup
- Using data clean rooms requires enabling the Analytics Hub API and assigning the required IAM roles, including Analytics Hub Admin for owners. source
- Analysis controls
- Contributors can configure analysis rules, including aggregation thresholds, to restrict how subscribers query shared data. source
- BigQuery sharing
- The service integrates with the BigQuery sharing platform, formerly called Analytics Hub. source
- BigQuery sharing
- Data clean rooms integrate with the BigQuery sharing platform, formerly called Analytics Hub. source
- Egress controls
- The service automatically prevents subscribers from copying or exporting raw data, and contributors can configure controls for query results. source
- Egress controls
- Data egress controls automatically prevent subscribers from copying or exporting raw data, and contributors can add controls for query results. source
- Founded
- 1998 source
- Headquarters
- Mountain View, California, United States source
- Interfaces
- The documentation describes managing clean rooms in the Google Cloud console and creating them through the API. source
- Limitations
- Analysis rules can be set only on views, and Google cautions that rules might not prevent sophisticated queries from extracting unauthorized data. source
- Pricing
- Data contributors are charged only for data storage, and subscribers are charged only for compute when they run queries. source
- Pricing basis
- Contributors are charged for data storage, while subscribers are charged for compute when they run queries. source
- Privacy controls
- Contributors can configure analysis rules, including an aggregation threshold rule that allows subscribers to analyze data only through aggregation queries. source
- Privacy limitation
- Google cautions that analysis rules might not prevent sophisticated queries from extracting unauthorized data and recommends query templates for approved-query control. source
- Purpose
- BigQuery Data Clean Rooms let multiple parties share, join, and analyze data without moving or revealing the underlying data. source
- Purpose
- BigQuery data clean rooms let multiple parties share, join, and analyze data without moving or revealing the underlying data. source
- Query templates
- Query templates let clean room owners and BigQuery sharing publishers provide predefined queries without sharing the underlying tables or views. source
- Query templates
- Owners and publishers can share predefined queries through query templates without sharing the underlying tables or views. source
- Regional availability
- Data clean rooms are available only in BigQuery sharing regions, and listings across multiple regions are not supported. source
- Regional availability
- Data clean rooms are available only in BigQuery sharing regions, and listings for multiple regions are unsupported. source
- Resource limit
- A data clean room can contain at most 100 shared resources; Google says to contact its feedback address to request an increase. source
- Resource limit
- A data clean room can contain at most 100 shared resources; Google directs users to contact [email protected] to request an increase. source
- Roles
- The product defines owner, contributor, and subscriber roles for managing rooms, publishing data, and querying shared data. source
- Shared resources
- A shared resource must be a BigQuery table, view, or table-valued function. source
Checked against the maker's pages on 3 Oct 2026.