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:

  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:

  SELECT * FROM SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.ADMIN.VERSION;
  

The following new features and enhancements are now available in Snowflake Data Clean Rooms:

• Single-account testing – You can now act as both provider and consumer in the single account for a test clean room. This should enable easier testing of clean room code for users with a single Snowflake account. Learn more.

• Configurable refresh rates for Cross-Cloud Auto-Fulfillment. The default refresh rate for provider clean room data to consumers located on other cloud hosting regions has been shortened from 24 hours to 30 minutes. The refresh rate for this data is configurable.

Source: Snowflake