Snowflake Data Clean Rooms: Tour of the web app

The web app of a Snowflake Data Clean Room provides an intuitive UI that allows business users to create and use clean rooms without worrying about code complexities.

This topic provides a quick tour of the user interface of the web app to give you an idea of the tasks that you complete as you work with a clean room. It describes the actions of the provider who creates and shares a clean room along with the consumer who uses that clean room.

Manage clean rooms and run analyses

Use the Clean Rooms page to manage the lifecycle of a clean room, including creating, sharing, and installing. As a consumer, you also use the Clean Rooms page to run new analyses in the clean room.

Clean room page in a clean room

On the Clean Rooms page you can do the following:

  • As a provider, select + Clean Room to create a clean room. The creation process is broken into 4 steps:

    1. Use the Add Data step to name the clean room and select the tables that are being shared with the consumer.

    2. Use the Specify Join Policies step to enhance your data with 3rd-party data and select which columns the consumer can join on.

    3. Use the Configure Analysis & Query step to define which analyses the consumer can execute in the clean room, and select the tables and columns that they can use in their analysis.

    4. Use the Share Clean Room step to invite consumers to use the clean room to collaborate.

  • As a provider, use the Created tab to list the clean rooms you have created.

  • As a consumer, you can install clean rooms that have been shared with you by a provider. To install a clean room:

    1. On the Invited tab, find the clean room and select Join.

    2. Select the tables that you want to use to collaborate with the provider’s data.

    3. Use the Join Policies field to define the relationship between your data and the provider’s data.

    4. Select Next.

  • As a consumer, you can run a new analysis based on the types of analyses that the provider has made available in the clean room. To run an analysis:

    1. On the Joined tab, find the clean room in the list and select Run.

    2. Select the analysis type, and select Proceed.

    3. Add filters to the analysis and select Run.

    4. Optionally, expand the Save Analysis & Query section to save the analysis for future use.

Manage and run analyses

Use the Analyses & Queries page to run existing analyses or create and run a new analysis.

Analyses and queries page in a clean room

On the Analyses & Queries page you can act as the consumer of a clean room and:

  • Use filters to find a particular analysis.

  • Select an analysis to run it and review results.

  • Select + New Analysis & Query to create and run a new analysis based on the types of analyses that the provider has made available in the clean room.

Add connectors

Use the Connectors page to configure data and ecosystem connectors so you can use them in your clean room.

Important

Third-party connectors are not offered by Snowflake and may be subject to additional terms. These integrations are made available for your convenience, but you are responsible for any content sent to or received from the integrations.

Connectors page in clean room

On the Connectors page you can:

  • Use the Data tab to configure data sources that you want to include in the clean room.

  • Use the Identity & Data Provider tab to configure an identity provider that you can use to enhance your data by providing better matching.

  • Use the Activation tab to configure the activation channels you would like to use to activate your target audience.

  • Use the Cleanrooms tab to configure a Snowflake, Amazon Marketing Cloud, or Ads Data Hub clean room for collaboration with your partner.

Add collaborators

Use the Collaborators page to add collaborators to your clean room environment. A clean room admin must add a party as a collaborator before users can share a clean room with them.

Collaborators page in clean room

On the Collaborators page you can:

  • Use the Snowflake Partners tab to make a Snowflake Customer a collaborator in your clean room environment.

  • Use the Managed Accounts tab to allow someone who is not a Snowflake customer to collaborate in your clean room. This collaborator uses a clean room managed account to run analyses in the clean room.

Configure the Snowflake account associated with a clean room

Use the Snowflake Admin page to sign in to the Snowflake account associated with the clean room environment so you can configure it for use with each clean room.

Snowflake Admin page in clean room

On the Snowflake Admin page you can sign in to the Snowflake account as a user with the ACCOUNTADMIN role. After signing in, you can do the following:

  • If this is the first time configuring the account for a clean room environment, you can:

    • Create a service user that represents the clean room environment so clean rooms can access the account.

    • Install the Snowflake Native App so clean rooms can interact with data in the account.

    • Register the databases that contain the data to share in a clean room.

    • Enable Cross-Cloud Auto-Fulfillment so users can share a clean room with collaborators in a different region.

  • If you are returning to this page after the initial configuration, you can:

    • Register new databases for the clean room environment.

    • Select Refresh so tables that have been added to a previously registered database are recognized within the clean room environment.

Manage users to your account

Use the User Management page to control who can use the web app.

User Management page in clean room

On the User Management page you can:

  • Add users.

  • Change the role of a user, which controls what they can do in the clean room.