Consumer activation in the web app¶

Some types of analyses allow a clean room user to activate results. In the case of a consumer-run analysis, one of the activation options is to push the results of the analysis to the consumer’s Snowflake account, where the consumer can access the data outside of the clean room.

Providers can configure their clean room environment to prevent the consumer from pushing results to the consumer’s Snowflake account. For more information, see Disable consumer activation.

Push results to Snowflake account¶

To activate results to their own Snowflake account, the consumer completes these steps:

After running the analysis, select Activate in the Results section.
Select the name of the consumer account.
In the Segment Name field, enter a descriptive name for the segment being activated.
Use the ID Columns drop-down list to select the columns that contain identifiers.
Optionally, use the Attribute Columns drop-down list to enrich results with values in the selected columns.
Select Push Data.

View analysis results in the consumer’s Snowflake account¶

The consumer can do the following to view the activation data in their Snowflake account:

Sign in to Snowsight.
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 » CONSUMER_DIRECT_ACTIVATION_SUMMARY.
3. Select Data Preview.
1. Open Projects » Worksheets.
2. Select + » SQL Worksheet.
3. To list the activation data that was pushed from the clean room environment, paste and run the following statement:
  SELECT * FROM samooha_by_snowflake_local_db.public.consumer_direct_activation_summary;
  
  Copy
  You can also use filters in your query to focus on a particular segment or clean room.

Disable consumer activation¶

The provider can configure their clean room environment to prevent consumers from pushing results to the consumer’s Snowflake account. Consumers do not see the option to push results to their own account unless the provider allows it.

To configure a clean room environment to prevent consumer activation, the provider completes these steps:

Sign in to the clean room environment in the web app.
Select Admin » Profile & Features.
In the Activation section, select Edit.
Clear Collaborator Account.