安装 Snowflake Data Clean Rooms 环境¶

Account, installer, and user requirements¶

When you install the clean rooms environment, you install it for all potential users in the Snowflake account. However, access to the clean rooms environment must be granted to users explicitly by a clean rooms administrator.

以下是在 Snowflake 账户中安装 Snowflake Data Clean Rooms 的要求：

• 账户必须是所需的 Snowflake 版本：

  • To create collaborations and be an owner, you must have Standard Edition or higher.

  • To join a collaboration as an analysis runner, you must have Standard Edition or higher.

  • To join a collaboration as a data provider or activate data to another collaborator, you must have Enterprise Edition or higher.

• The installer must fulfill these role and user requirements.

• 不支持阅读者账户， 因为阅读者账户不允许共享安装和运行 Clean Room 应用程序所需的数据。

• You must accept data sharing terms. If you have not accepted the Snowflake Customer-Controlled Data Sharing Functionality Terms, please contact Snowflake Support. Snowflake Data Clean Rooms leverage listings, which are part of the Snowflake Service and subject to your Service terms with Snowflake, including the Snowflake Customer-Controlled Data Sharing Functionality Terms and Snowflake Acceptable Use Policy.

• You must unset any unsupported account-level parameters. See the list of unsupported account-level settings.

如果您不满足所有这些要求并需要升级，请联系 Snowflake 支持部门。

Unsupported account-level parameters¶

Snowflake Data Clean Rooms does not support certain account-level parameter values. The following table shows the required values for these parameters:

To check a parameter in your account, run the following SQL command, substituting the parameter name for <parameter_name>:

SHOW PARAMETERS LIKE '<parameter_name>' IN ACCOUNT;

For example:

SHOW PARAMETERS LIKE 'DEFAULT_DDL_COLLATION' IN ACCOUNT;

Role and user requirements¶

Here are the role requirements for the person installing the clean rooms environment:

• You must have an ACCOUNTADMIN role in a Snowflake account in order to install the clean rooms environment in that account.

• 具有 ACCOUNTADMIN 角色的用户必须为其用户对象定义有效的名字、姓氏和电子邮件。要进行检查，请运行 DESCRIBE USER。

1.安装原生应用程序¶

通过 Marketplace 安装原生应用程序：

1. 则将您当前的角色设置为 ACCOUNTADMIN

2. 从 Snowflake Marketplace 安装 Snowflake Data Clean Room 应用程序

3. Select Open and accept the default options.

Installation takes several minutes. When done, proceed to step 2.

2. 安装 Clean Room API¶

The clean rooms API is required to use clean rooms either through the UI or the API.

以下是在您的 Snowflake 账户中安装 Clean Room API 的步骤：

1. After installing the native application, launch it in Snowflake. In the navigation menu, select Catalog » Apps » Snowflake Data Clean Rooms. Click the Open in Worksheet button at the top right corner. This opens a worksheet with SQL commands.

2. 运行 SQL 命令安装 Clean Room API 的注意事项如下：

   • 如果在安装过程中重命名了原生应用程序，则需要按照脚本注释中的说明修改脚本。

   • 如果想在运行前查看完整的安装脚本，请取消 DRY_RUN=TRUE 脚本行的注释，然后运行包括该行在内的所有命令，以查看脚本内容。请注意，不要手动运行该命令暴露的安装脚本，否则可能导致安装不完整。

   • 请注意，安装需要几分钟时间。

3. 确认可以访问 API：

   CopyExpand

   USE ROLE SAMOOHA_APP_ROLE;
   USE WAREHOUSE app_wh;
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.LIBRARY.CHECK_MOUNT_STATUS();
   

   Show lessSee more

   Scroll to top

   If this returns FALSE, confirm you are using SAMOOHA_APP_ROLE and if so please retry running the mount script command by ACCOUNTADMIN role again.