Snowflake Data Clean Rooms: Snowsight UI is now GA

Use cases

Imagine you manage sensitive data collaborations and need a visual interface to audit runs, review invitations, and manage templates without complex commands. You can do the following:

• Browse, create, and manage collaborations directly in Snowsight.
• Track template execution history in the new Activity tab.
• Review collaboration invite details before joining.
• Check your current API environment version.

How to use

To check your clean rooms API environment version number, run the following SQL command:

SELECT * FROM SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.ADMIN.VERSION;

What happens in this code:

1. The statement queries all columns from the version table in the local Data Clean Rooms database.
2. The output displays the active version number installed in your environment, such as version 18.5.

For administrators wanting to enable automatic API updates, use the following command block:

USE ROLE SAMOOHA_APP_ROLE;
CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.library.enable_local_db_auto_upgrades();

What happens in this code:

1. Sets the active role to SAMOOHA_APP_ROLE to ensure proper administrative privileges.
2. Calls the stored procedure that enables automatic updates for the local application database.

Limitations and requirements

• The Snowsight UI is GA, but the feature is not available in government and VPS deployments.
• UI users must log out and log back in to apply newly deployed updates.
• Accounts on version 12.3 or earlier may require a manual remount procedure before automatic updates work again.