Data Clean Rooms

Snowflake Management, Governance & Collaboration

Emily Melhuish

Technical Curriculum Developer, Snowflake

Collaboration Without Exposure

Diagram showing two organizations with customer data on either side, connected by a question mark representing the overlap count result, with a barrier preventing raw data from crossing

Claro and RetailCo want to measure customer overlap
Neither can share raw customer lists: both contain PII
Standard sharing gives each party the other's raw records
A clean room enables the answer without the exposure

What is a Data Clean Room?

Secure environment built on the Native App Framework
Both parties contribute data to the environment
Only approved queries run against the combined data
Only aggregate results exit: raw records never leave

Clean room.png

¹ https://www.snowflake.com/en/product/features/data-clean-rooms/

How Do Snowflake Clean Rooms Work?

Step-by-step flow diagram: Claro contributes customer data, RetailCo contributes customer data, an approved join query runs on hashed identifiers inside the clean room, and a single overlap count exits

Join on hashed customer identifier

Provider and Collaborator Roles

Provider (Claro)

Creates and configures the clean room
Defines permitted queries and allowed results
Maintains control over the privacy boundary

Collaborator (RetailCo)

Joins the clean room and contributes data
Runs approved queries only
Cannot modify query logic or access rules

Diagram showing Provider on the left with admin controls and Collaborator on the right with query-only access

Clean Rooms vs Secure Data Sharing

When to use clean rooms and when to use secure data sharing?

Dimension	Secure Sharing	Clean Room
Raw data access	Consumer queries raw objects	Neither party sees the other's raw data
Use case	Distribute data to a partner	Joint collaboration without exposure
Who controls query	Consumer writes any query	Provider pre-approves all queries
Common examples	Credit data, market feeds	Audience overlap, fraud consortia, campaign measurement

Let's practice!

Snowflake Management, Governance & Collaboration