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();
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();
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();
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
.