June 25, 2024 — Snowflake Data Clean Rooms Release Notes

With this release, we are pleased to announce the availability of the following new features and enhancements in this update to Snowflake Data Clean Rooms.

Provider-run analyses

The provider of a clean room can now run analyses in their own clean room. This feature allows providers to directly extract insights from data shared by the consumer within the clean room. Previously, providers could only be a data provider.

Consumer-defined templates

Consumers can now request that a provider allow them to add their own template to a clean room. After a request is raised, a provider can review the template definition and decide whether to accept or reject the consumer’s request to add the template.

Because a consumer is often in the best position to know how to extract insights from data coming from multiple providers, the ability to add a consumer-defined template is especially important when the consumer wants to execute a multi-provider analysis.

For more information, see Using the developer API to add consumer-defined templates.

Granular access controls for tables & templates

Providers can now control which consumers can access a specific table or template in the clean room. This allows a provider to share the same clean room with multiple consumers without giving full access to every consumer. Previously, all consumers could access a table or template if it was included in the clean room.

Developers can now specify which consumers can access a table or template when executing the API to add it to the clean room. In addition, the following new APIs control access:

  • provider.restrict_table_options_to_consumers

  • provider.restrict_template_options_to_consumers

For more information about these APIs, see Snowflake Data Clean Rooms: Provider API reference guide.

Activating results across regions

Consumers can now activate results back to the provider even if the provider is in a different cloud/region. To take advantage of this enhancement, consumers must enable cross-cloud auto-fulfillment on their account.

SQL Template enhancement

When a provider allows another party to query data via the SQL template, the provider can now specify custom aggregation threshold values for each entity column they want to protect. This provides more flexible controls from the previous version of privacy controls, which applied the same aggregation threshold across all join columns. Additionally, users no longer need to supply provider [p] & consumer [c] aliases for tables and columns.