Collaborate in a Clean Room

Set up a query in a Data 360 clean room collaboration to compare a consumer segment with the provider's data, without exposing raw records. Run a query manually for an immediate output, or schedule it to run each time the segment publishes.

Required Editions

Available in: Enterprise Editions (home org)

User Permissions Needed
To run a clean room query:	Data Cloud Architect OR Data Cloud Activation Manager OR Data Cloud Activation Specialist

Run a Query

Run a query to get insights on your collective data. To run a query, the collaboration must be active.

1. In Data 360, go to the Clean Rooms tab.
2. Under Collaborations, open the collaboration to run the query on.
3. Click Set Up Query.
4. For Run Options, select Run now.
5. If the use case includes more than one query, select a query for Query Name.
6. For Query Run Name, enter a descriptive name that identifies this run in the Collaboration Results tab.
7. For Consumer Segment, select the segment to compare.
8. If the query uses parameters, enter a value for each parameter.
9. Click Run Query.
   After the run completes, the result appears on the Collaboration Results tab. If a schedule already runs for the segment, Data 360 asks you to confirm. Click Run Anyway to run the query now. A manual run doesn't change the scheduled run.

Schedule a Query to Run on Segment Publish

Schedule a query to run automatically each time the consumer segment publishes. To schedule a query on segment publish, the collaboration must be active and the consumer segment must already have a publish schedule.

1. In Data 360, go to the Clean Rooms tab.
2. Under Collaborations, open the collaboration to run the query on.
3. Click Set Up Query.
4. For Run Options, select Schedule based on segment publish.
5. For Schedule Name, enter a descriptive name that identifies this schedule later.
6. If the use case includes more than one query, select a query for Query Name.
7. For the Consumer Segment, select the segment to compare. Review the Segment Publish Summary to confirm the segment's Type, Frequency, Run Every, Start Date and Time, and End Date and Time.
8. If the query uses parameters, enter a value for each parameter.
9. Click Schedule Query.
   The schedule appears on the Scheduled Queries tab.

Note You can schedule only one query run for each consumer segment. For a custom template that uses parameters, you can schedule one run for each combination of segment and parameter values.