About Snowflake Data Clean Rooms¶
A Snowflake Data Clean Room is a native solution that makes it easy to build, connect, and use data clean rooms in Snowflake.
Data clean rooms offer a secure way to gain valuable insights while protecting sensitive information. They allow you to combine and analyze data from different parties with, privacy-preserving configurations that help protect the underlying data.
Benefits of data clean rooms include:
Enhanced privacy — Protects sensitive data while enabling collaboration.
Deeper insights — Combines data from multiple sources for richer analysis.
Increased security — Reduces the risk of unauthorized access.
How Snowflake Data Clean Rooms work¶
With Snowflake Data Clean Rooms, all analyses are conducted within the secure environment of the clean room. Collaborators are able to return aggregated results and insights, but cannot directly query the raw data in the clean room. The collaborator who is sharing their data can define what analyses are available to the other collaborators, allowing them to tightly control how their data is used.
A Snowflake Data Clean Room also uses privacy-enhancing techniques on its data such as:
Using differential privacy to add noise to results in order to prevent someone from identifying whether a particular individual is in the data.
Clean room collaborators¶
Snowflake Data Clean Rooms use the concept of a provider and consumer, similar to other Snowflake features like Secure Data Sharing. The data owner is a provider who uses a clean room to safely share data with a consumer. The consumer installs the clean room in their own account and analyzes data in the clean room, including joining their own data with the data of the provider.
Tasks associated with clean room collaborators include:
- Provider:
Create a clean room.
Add data to a clean room.
Configure a clean room to control how a consumer can interact with data.
Share a clean room with a consumer.
- Consumer:
Install a clean room.
Add datasets to the clean room.
Analyze data in the clean room, including joining consumer data with the provider’s data.
Within the clean room environment associated with a Snowflake account, a collaborator can be the provider of one clean room while acting as the consumer of another.
If you want to collaborate with someone who is not currently a Snowflake customer, see Clean room managed accounts.
For information about adding a collaborator to your clean room environment, see Add potential collaborators to the environment.
Working with Snowflake Data Clean Rooms¶
You have two ways to interact with clean rooms:
Web app — An easy-to-use interface that makes privacy-enhanced data collaboration accessible to a wide base of users, including non-technical business users. Collaborators can use pre-defined analysis templates including audience overlap, reach and frequency, and last touch attribution. For an overview, see Snowflake Data Clean Rooms: Web app overview.
Developer APIs — A complete set of APIs that allow a technical audience to work with clean rooms programmatically, including the ability to build custom applications and to customize analysis templates and ML models. For an overview, see Snowflake Data Clean Rooms developer guide.
Next Steps¶
Your next steps depend on how you got here and what you want to do:
If you got an invitation to join a clean room:
Open the clean room in your browser:
Select Log in in your invitation email to sign in to your clean rooms account.
Sign in with the email address that got the email.
Provide the password for this account.
If you get an account chooser, refer to the email to see which account this clean room is in.
When the web app opens, navigate to Clean Rooms > Invited.
Choose a clean room and select Join to install the clean room.
Configure the clean room by providing data from your account, specifying which columns to join on (if asked) and providing further customizations, such as which provider tables and columns to use in the query.
Click Finish to run the query and optionally specify a repeating run. It will take some time for the query to run; you can track progress and see results in the Analyses & Queries tab.
Read the getting started page for background. Remember that the clean rooms environment is already installed for your account.
If you plan to use only the web application, read about installing and using clean rooms. You must install new clean rooms in your account in order to use them; the clean room environment itself is already installed.
If you are a Snowflake administrator and are interested in installing the clean rooms environment in your Snowflake account:
Read getting started page for background and installation prerequisites.
Read the overview of roles.
Understand the costs associated with clean rooms.
If you are a developer:
If clean rooms are already installed in your Snowflake account, read getting started page for background.
Read the developer API overview and try out the API tutorial.