Snowflake Partner Connect

Partner Connect 可让您轻松向选定的 Snowflake 业务合作伙伴创建试用账户,并将这些账户与 Snowflake 集成。此功能提供了一个方便的选项,供您尝试各种第三方工具和服务,然后采用最能满足您的业务需求的工具和服务。

支持的合作伙伴

Important

Snowflake 既不决定也不规定合作伙伴试用账户的条件或条款(时长、支持的功能等);这些政策由各个 Snowflake 合作伙伴制定,并因合作伙伴而异。

有关特定试用的详细信息,请直接联系合作伙伴。

目前,Partner Connect 包括以下合作伙伴:

安全要求

Partner Connect is limited to account administrators (i.e. users with the ACCOUNTADMIN role) who have a verified email address in Snowflake:

  • 要使用 Partner Connect,您必须切换到 ACCOUNTADMIN 角色或联系组织中具有该角色的人员。

  • 要验证您的电子邮件地址,请执行以下操作:

    Snowsight:

    In some cases, you automatically receive an email prompting you to Please Validate Your Email. If you didn’t, follow these steps to verify your email address:

    1. sign in to Snowsight.

    2. in the lower-left corner, select your name » Settings.

    3. In My Profile, configure your email address:

      • If you don’t have an email address listed, enter an email address in the Email field, and then select Save.
      • If you can’t enter an email address, an account administrator must either add an email address on your behalf or grant your user the role with the OWNERSHIP privilege on your user.
      • If you didn’t receive an email, select Resend verification email. Snowflake sends a verification email to the address listed.
    4. Open your email, and then select the link in the email to validate your email address.

与 Snowflake 合作伙伴建立关联

要向当前在 Partner Connect 中的任何 Snowflake 合作伙伴启动试用账户,请执行以下操作:

  1. Sign in to Snowsight.
  2. To switch to the account administrator role, in the lower-left corner, select your name » Switch role » ACCOUNTADMIN.
  3. In the navigation menu, select Admin » Partner Connect.
  4. 点击您要与其关联的合作伙伴的相应磁贴。

对话框显示与合作伙伴建立关联的要求,以及关联过程中在 Snowflake 中自动创建的对象列表,包括空数据库、仓库、默认用户和自定义角色。合作伙伴应用程序在从您的账户中读取或向其写入时使用这些对象。

  1. Optionally specify one or more existing databases in Snowflake to automatically use with the trial. This creates an additional custom role that makes existing data in Snowflake quickly and easily available to the partner application.

如果在初始关联过程中没有指定任何数据库,可以稍后再指定;但是,稍后必须手动指定。

要将共享数据库用于试用,请执行以下操作:

  • Use Snowsight to complete the initial connection process.
  • 该过程完成后手动指定共享数据库。
  1. Click the Connect button below the partner description to initiate creating a trial account with the partner and connecting the partner application to Snowflake.

该过程完成并创建对象后,合作伙伴磁贴将更新并带有复选标记。

为合作伙伴创建的对象

在关联过程中,将在您的账户中创建合作伙伴应用程序的以下 Snowflake 对象:

Object NameTypeNotes
PC_<partner>_DBDatabaseThis database is empty and can be used to load/store data for querying. If you wish to use existing databases that already contain data, during the initial connection process, you can specify any non-shared databases to use in the field provided. You can also manually specify other databases after the process completes.
PC_<partner>_WHWarehouseThe default size of the warehouse is X-Small, but can be changed if needed.
PC_<partner>_USERSystem UserThis is the user that connects to Snowflake from the partner application. As noted in the dialog, a random password for the user is automatically generated.
PC_<partner>_ROLERoleThe PUBLIC role is granted to this custom role, which enables the role to access any objects owned/granted to the PUBLIC role. In addition, this role is granted to the SYSADMIN role, which enables users with the SYSADMIN role (or higher) to also access any Snowflake objects created for partner access.

此外,如果您选择在初始关联过程中指定一个或多个现有数据库,则会创建第二个自定义角色,该角色具有访问数据库中的表的所有必要权限:

PC_<partner>_DB_PICKER_ROLE

This role is then granted to the PC_<partner>_ROLE, which enables all the tables in the specified databases to be used by the partner application with minimal (or no) additional configuration.

请注意,第二个角色不会显示在对话框中,但该角色会在对话框中列出的所有其他对象创建后自动创建。

Tip

创建上述对象是为了快速、方便地进行设置:

  • If you prefer to use existing Snowflake objects (databases, warehouses, users, etc.), you can update the preferences in the partner application to reference the desired objects in Snowflake.
  • An account administrator can use ALTER USER to change the generated password for PC_<partner>_USER.
  • To enable access to objects owned by (or granted to) roles other than PUBLIC, grant the other roles to PC_<partner>_ROLE.

自动化的应用程序功能和资源使用情况

Partner applications may include automated features such as dashboards that run on a schedule and consume compute resources. We encourage you to read the product documentation for a partner application and to monitor usage of the PC_<partner>_WH warehouse to avoid unexpected Snowflake credit usage by the application.

向网络策略中添加合作伙伴 IP 地址

If you use a network policy to restrict access to your Snowflake account based on user IP address, partner applications will not be able to access your account unless you add the partner’s IP addresses to the list of allowed IP addresses in the network policy. For detailed instructions, see Modify a network policy.

下表列出了为每个合作伙伴添加的 IP 地址(如有且受支持),或提供了执行合作伙伴网站上包含此信息的页面的链接:

PartnerIP AddressesNotes
ALTR3.145.219.176/28
35.89.45.128/28
44.203.133.160/28
CARTON/A
CoalesceN/A
DataikuN/A
dbt Labs52.22.161.231
52.45.144.63
54.81.134.249
DomoN/A
EtleapN/A
Fivetran52.0.2.4For more setup details, see the Fivetran Documentation (https://fivetran.com/docs/warehouses/snowflake).
Hunters18.192.165.147
34.223.20.125
34.223.186.164
34.223.221.217
52.32.222.121
52.35.55.27
52.35.219.75
52.40.78.172
54.68.155.124
54.72.125.231
54.73.199.243
54.75.50.99
54.212.81.93
54.214.94.117
54.220.191.11
Hevo Data CDC for ETLTBD
HexN/A
HightouchN/A
InformaticaN/A
Informatica Data LoaderN/A
KeboolaN/A
Matillion Data Productivity CloudN/A
Sigma104.197.169.18
104.197.193.23
SnapLogicVariousFor the IP addresses, see the SnapLogic Documentation (https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439269/Network+Setup#NetworkSetup-IPAddressWhitelisting).
SqlDBMN/A
StriimN/A
ThoughtSpot35.164.213.211

启动合作伙伴应用程序

合作伙伴应用程序关联到 Snowflake 后:

  1. On the Snowflake Partner Connect page, click the corresponding tile.
  2. Click the Launch button to open the partner web site.

与合作伙伴账户取消关联

如果您因任何原因决定终止通过 Partner Connect 启动的试用账户,请完成以下步骤:

  1. Sign in to Snowsight.

  2. To switch to the account administrator role, in the lower-left corner, select your name » Switch role » ACCOUNTADMIN.

  3. In the navigation menu, select Admin » Partner Connect.

  4. Click the tile for the partner application you are disconnecting from. In the dialog that opens, note the names of the database, warehouse, system user, and custom role objects that were created for the partner application during the initial connection process.

  5. Use the appropriate DROP <object> command to remove each of the objects created for the partner application.

    Tip

    During the initial connection process, if you specified existing databases to use with the partner application, remember to also drop the PC_<partner>_DB_PICKER_ROLE role that was automatically created along with the other objects.

  6. Open a new worksheet in Snowsight and run the following command to complete the removal of the partner connection:

    select system$remove_etl_integration('partnername');

    Replace <partner_name> with the name of the partner application you are disconnecting from.

  7. 如果试用没有自行过期,请联系合作伙伴以结束您对试用的参与。

排除关联故障

关联已存在

如果您的组织已拥有合作伙伴账户(直接通过合作伙伴启动或使用 Partner Connect 在另一 Snowflake 账户中启动),则启动另一个试用账户可能会失败,并显示一条消息,表明关联已存在。

在这种情况下,该账户的试用必须直接通过合作伙伴启动。