Enabling updates
• Clean room UI users: Sign out and back in to the clean rooms UI for these updates to take effect.
• Clean room API users: 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 apply updates automatically without calling apply_patch for each update, run the following SQL commands:
USE ROLE SAMOOHA_APP_ROLE;
CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.library.enable_local_db_auto_upgrades();
You can see the clean rooms API version by running the following SQL command:
SELECT * FROM SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.ADMIN.VERSION;
The following new features and enhancements are now available in Snowflake Data Clean Rooms:
• Simplified flow for cross-region sharing. Previously a provider needed to call both request_laf_cleanroom_requests and mount_laf_cleanroom_requests_share to receive requests from the consumer when the consumer account is in a different region. Now the provider can simply call mount_request_logs_for_all_consumers instead.
• Simplified installation. Instead of requiring the user to create and verify a service user, clean rooms now automatically creates and verifies a service user, or reuses an existing service user. This greatly simplifies the installation process.
Source: Snowflake
