Scheduling a repeating analysis in the clean rooms UI

End-of-life notice

The legacy Provider and Consumer Data Clean Rooms are being discontinued. Migrate to the Collaboration API using the migration tool before the dates below.

Some types of analyses can be scheduled to run automatically at a regular interval. These analyses include the following:

  • SQL Query template
  • Audience Overlap & Segmentation template
  • Custom templates created using the developer APIs

An administrator must configure the clean room environment to allow scheduled analyses before a user can schedule an analysis to repeat.

Limitation: Only consumers can schedule analyses.

Enable scheduled analyses

A clean rooms account administrator must configure an account to allow scheduled analyses.

To enable scheduled analyses in a clean room account:

  1. Sign in to the clean rooms UI.
  2. In the left navigation, select Admin » Snowflake Admin.
  3. Select Login to Snowflake, and authenticate as a Snowflake user with the ACCOUNTADMIN role.
  4. In the Account Features section, enable Schedule Analysis Run.

Scheduling a repeating analysis

If an analysis template supports scheduling analyses, you can configure an analysis to repeat at a regular interval when you run it for the first time in the clean room. When prompted to save the analysis, use the Schedule Run drop-down list to select an interval.

Modify or disable a scheduled analysis

If you want to change the scheduled interval for an analysis or turn off scheduling, complete these steps:

  1. Sign in to the clean rooms UI.
  2. In the left navigation, select Analyses & Queries.
  3. Find the analysis in the list and select it.
  4. Expand the Save Analysis & Query section, and use the Schedule Run drop-down list to make the change.