April 10, 2025 — Snowflake Data Clean Rooms updates

Note

Clean rooms UI users must sign out and back in to the clean rooms UI for these updates to take effect.

Clean rooms API users must run the following code for these updates to take effect:

USE ROLE SAMOOHA_APP_ROLE;
CALL samooha_by_snowflake_local_db.library.apply_patch();
Copy

To enable auto-upgrades for API users, run the following code:

USE ROLE SAMOOHA_APP_ROLE;
CALL samooha_by_snowflake_local_db.library.enable_local_db_auto_upgrades();
Copy

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:

Column policies are optional for provider-run analysis: This applies only to clean rooms API users.

Google Ads activation connector is now available from the DCR. Google Ads now requires customers to check two check boxes affirming that the DCR collaborator activating the analysis output with Google Ads have obtained data subject consents for advertising purposes and for ad personalization.

Additional procedures supported by grant_run_on_cleanrooms_to_role. Additional procedures are now supported by roles granted clean room privileges using consumer.grant_run_on_cleanrooms_to_role.

Important

To support the additional procedures in grant_run_on_cleanrooms_to_role, the provider and consumer must run the following procedures in this order:

  1. Provider:

    CALL samooha_by_snowflake_local_db.provider.patch_cleanroom($cleanroom_name, TRUE);
    Copy

  2. Consumer:

    CALL samooha_by_snowflake_local_db.consumer.patch_cleanroom($cleanroom_name);
    Copy

Clean rooms now support Snowpark Container Services. You can run a Snowpark container within a clean room for large jobs in custom Snowpark environments. Learn more.

Language: English