Snowflake Partner Connect¶
Easily create trial accounts with one or more of Snowflake’s business partners and integrate those accounts with Snowflake. This feature provides a convenient means to try additional tools and services and adopt the ones that meet your business needs.
In this Topic:
Currently, Partner Connect supports the following partner services:
Support for additional Snowflake partners is planned.
The guidelines and policies (trial length, supported features, etc.) for a partner trial account vary by Snowflake partner. For more information about a specific trial, contact the partner directly.
Partner Connect is limited to account administrators (i.e. users with the ACCOUNTADMIN role) who have a verified email address in Snowflake:
- To use Partner Connect, you must switch to the ACCOUNTADMIN role or contact someone in your organization who has that role.
- To verify your email address:
- In the Snowflake web interface, select Preferences » General from the dropdown menu next to your login name. The Preferences page appears.
- In the User Information area, add or verify your email address by clicking the appropriate link(s) in the Email Address field.
Connecting with a Snowflake Partner¶
To initiate a trial account with any Snowflake partner currently included in Partner Connect:
Log into the Snowflake web interface.
Click the dropdown menu next to your login name » Switch Role » ACCOUNTADMIN to change to the account administrator role.
To read a description of an application and its requirements, click on the corresponding partner button.
Click the Connect button below the partner description to initiate creating a trial account with the partner and connecting the partner application to Snowflake.
Note that connecting a partner application with Snowflake automatically creates a set of related objects in Snowflake, including a database, warehouse, default user, and custom role. The partner application uses these objects when reading from or writing to your account.
Security Roles, Users, and Objects Created by the Partner¶
During the connection process, the partner application creates the following objects:
|Role||PC_<partner_name>_ROLE||The PUBLIC role is granted to this 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 or ACCOUNTADMIN role to also access the Snowflake objects created for partner application access.|
To enable PC_<partner_name>_ROLE to access objects owned/granted to other roles, grant these other roles to the role.
Modifying Network Policies¶
If you use Network Policies to restrict access to your Snowflake account based on user IP address, you must add the partner IP addresses to the list of allowed IP addresses for your active account policy. For instructions, see Modifying a Network Policy.
The following table indicates the IP addresses for each partner or links to a page on the partner site for this information:
|Snowflake Partner||IP Addresses||Link to Partner IP Addresses|
|Alooma||Alooma IP addresses|
|Fivetran||Fivetran IP addresses|
|Periscope Data||Periscope Data IP addresses|
|Stitch||Stitch IP addresses|
Launching Partner Applications¶
After a partner application is connected to Snowflake, click the corresponding button on the Snowflake Partner Connect page. Click the Launch button to open the partner application web site.
Disconnecting from a Partner Account¶
If you decide to discontinue a trial account initiated through Partner Connect for any reason, complete the following steps:
- Log into the Snowflake web interface.
- Click the user menu » Switch Role » ACCOUNTADMIN to change to the account administrator role.
- Click the Partner Connect tab. The Snowflake Partner Connect page opens.
- Click on the button for the partner application you are disconnecting from. Note the names of the database, warehouse, system user, and role objects created for the partner application.
- Use the corresponding DROP <object> command to drop each of the objects created by the partner connection.
- Contact Snowflake Support to stop the partner account trial and remove the checkmark from the Partner Connect button.
Troubleshooting a Connection¶
Connection Already Exists¶
If your organization already has an account with the partner, initiated either with the partner directly or using Partner Connect on another one of your Snowflake accounts, initiating another trial account might fail with a message that a connection already exists.
In this case, the trial for this account must be initiated directly through the partner.