Snowflake Data Clean Rooms updates

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