Configure and view clean rooms

A clean room is a data listing that features datasets and queries where partners are restricted on what they can run. For example, use a clean room when you want to run an analysis on the intersection of hashed user emails between two companies, but you don’t want to expose your full dataset.

You can view the Snowflake Clean Room API tutorial for the latest information on API calls to set up and interact with the shared clean room environment.

Install a clean room

Ensure you have met the following prerequisites:

• Sent a screenshot of the pertinent Snowflake account information to your Instacart representative or emailed it to data-hub@instacart.com. See Partner Snowflake Account.
• Created a Snowflake account with appropriate privileges. For more information, see Configure your Snowflake environment.
• Created an ACCOUNTADMIN role or equivalent permissions.
• Contacted your Instacart representative.

Install the Snowflake Data clean rooms application in your account.

1. Navigate to the Snowflake Marketplace in your Snowflake account.
2. Search for Snowflake Data clean rooms.
3. To install the application, click Get.
4. When prompted, accept the terms and grant necessary privileges.

The application will be installed as samooha_by_snowflake_local_db.

Install the specific clean rooms

After installing the applications, install the specific clean rooms shared by Instacart by running the following query. Replace the following parameters:

• CLEANROOM_NAME with the clean room name provided by Instacart.
• PROVIDER_LOCATOR with the account locator name provided by Instacart.

call samooha_by_snowflake_local_db.consumer.install_cleanroom('CLEANROOM_NAME','PROVIDER_LOCATOR');

Verify a clean room has been installed

Run the following query:

call samooha_by_snowflake_local_db.consumer.is_enabled();

View available clean rooms

Run the following query:

call samooha_by_snowflake_local_db.consumer.view_installed_cleanrooms();

Verify role permissions

Run the following query:

show roles;

Verify the clean room configuration

Run the following query to get details about your clean room. Replace CLEANROOM_NAME with the clean room name provided by Instacart.

call samooha_by_snowflake_local_db.consumer.describe_cleanroom('CLEANROOM_NAME');

Link your data

important

Only the Overlap Analysis template requires consumer data linking. The other templates use only Instacart's data and do not require you to register or link your own data in the clean room.

To link your data with the Overlap Analysis template, see Overlap Analysis.