May 29, 2025 — Snowflake Data Clean Rooms updates

Note

  • 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();
    
    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:

  • Free-form SQL queries now available in the API. You can now expose your linked tables and views in a clean room to be available for free-form queries by clean room collaborators in any Snowflake coding enviroment.