May 1, 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 SQL commands 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 SQL commands:

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 to Snowflake Data Clean Rooms:

Sign in to clean rooms with your Snowflake credentials. Snowflake users in new clean room accounts can now sign in to the clean rooms UI using their Snowflake credentials.

Activation methods added to run roles. Users granted run roles can now activate their data. See the full list of procedures available to run role users.

Differential privacy is now a managed task, which lowers the cost to clean room owners. This feature will be enabled automatically for any new clean room accounts. If your have an existing clean room account and want to migrate your differential privacy to a managed task, run the following code:

USE ROLE ACCOUNTADMIN;
GRANT EXECUTE MANAGED TASK ON ACCOUNT TO ROLE SAMOOHA_APP_ROLE;

USE ROLE SAMOOHA_APP_ROLE;
CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.LIBRARY.SETUP_TASK_PROVIDER();
Copy

Provider activation warehouse management. Providers can now choose the size of the warehouse used to decrypt and store provider activation results by calling provider.update_activation_warehouse.