Provider activation in the web app

Some types of analyses allow a clean room user to activate results. One of the activation options is to push the results of the analysis to the provider’s Snowflake account. The consumer can push results back to the provider or, in the case of provider-run analyses, the provider can push the results to their own Snowflake account.

In both cases, the results of the analysis are pushed to the provider’s Snowflake account outside of the clean room.

Push results back to the provider

To activate results back to the provider’s Snowflake account, complete these steps:

  1. After running the analysis, select Activate in the Results section.

  2. Select the name of the provider account.

  3. In the Segment Name field, enter a descriptive name for the segment being activated.

  4. Use the ID Columns drop-down list to select the columns that contain identifiers.

  5. Optionally, use the Attribute Columns drop-down list to enrich results with values in the selected columns.

  6. Select Push Data.

View analysis results in the provider’s Snowflake account

The first time a collaborator pushes data to the provider’s Snowflake account, the provider must sign in to the web app to establish a data pipeline. This only needs to be done once. To establish the data pipeline, the provider must:

  1. Sign in to the clean room environment in the web app.

  2. Stay signed in to the web app for 30-60 minutes.

After the data pipeline has been established, the provider can do the following to view the activation data in their Snowflake account:

  1. Sign in to Snowsight.

  2. Use a SQL query or the database object explorer in Snowsight to view the data:

    1. In the left navigation, select Data » Database.

    2. Navigate to SAMOOHA_BY_SNOWFLAKE_LOCAL_DB » PUBLIC » Tables » PROVIDER_ACTIVATION_SUMMARY.

    3. Select Data Preview.

Language: English