Snowflake Partner Connect

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake. This feature provides a convenient option for trying additional tools and services, and then adopting the ones that best meet your business needs.

In this Topic:

Supported Partners

Currently, Partner Connect includes the following partners:

Partner

Category

Notes

Chartio

Business Intelligence (BI)

data.world

Security & Governance

Dataguise

Security & Governance

Dataiku

Machine Learning & Data Science

Datalytyx

SQL Development & Management

Datalytyx DataOps

DataRobot

Machine Learning & Data Science

Domo

Business Intelligence (BI)

Fivetran

Data Integration

Hunters.AI

Security & Governance

Informatica

Data Integration

Informatica Cloud

Matillion ETL

Data Integration

Matillion ETL

Matillion Data Loader

Data Integration

Matillion Data Loader

Qlik

Data Integration

Qlik Replicate

Rivery

Data Integration

Sigma Computing

Business Intelligence (BI)

Sisense

Business Intelligence (BI)

Sisense for Cloud Data Teams

SnapLogic

Data Integration

SqlDBM

SQL Development & Management

Stitch

Data Integration

Striim

Data Integration

ThoughtSpot

Business Intelligence (BI)

Zepl

Machine Learning & Data Science

Important

Snowflake neither determines nor dictates the conditions or terms (length, supported features, etc.) for partner trial accounts; these policies are set by each Snowflake partner and vary according to the partner.

For details about a specific trial, please contact the partner directly.

Security Requirements

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 the role.

  • To verify your email address:

    1. In the Snowflake web interface, select Preferences » General from the dropdown menu next to your login name. The Preferences page appears.

    2. 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:

  1. Log into the Snowflake web interface.

  2. Click the dropdown menu next to your login name » Switch Role » ACCOUNTADMIN to change to the account administrator role.

  3. Click on Partner Connect Partner Connect tab. The Snowflake Partner Connect page opens.

  4. To read a description of an application and its requirements, click on the corresponding partner button.

  5. 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 Snowflake objects in your account:

Object

Name

Notes

User

PC_<partner_name>_USER

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 role (or higher) to also access any Snowflake objects created for partner application access.

Database

PC_<partner_name>_DB

Warehouse

PC_<partner_name>_WH

Tip

  • This set of objects is created to enable a quick, convenient setup. If you prefer to use existing Snowflake objects instead, you can update the preferences in the partner application to use those objects.

  • An account administrator can use ALTER USER to change the generated password for the PC_<partner_name>_USER user.

  • To enable access to objects owned/granted to other roles, grant the roles to PC_<partner_name>_ROLE.

Automated Application Features and Resource Usage

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 warehouse created for the application (i.e. PC_<partner_name>_WH) to avoid unexpected Snowflake credit usage.

Adding Partner IP Addresses to Network Policies

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 an Account-level Network Policy.

The following table lists the IP addresses to add for each partner (if available) or provides links to pages on the partner sites for this information:

Partner

IP Addresses

Notes

Chartio

Various

See the Chartio Support site for the addresses.

data.world

52.3.83.134 , 52.205.195.10 , 52.205.207.86

Dataguise

N/A

Dataguise does not currently provide a range of static IP addresses.

Dataiku

TBA

Datalytyx

TBA

DataRobot

TBA

Domo

TBA

Fivetran

52.0.2.4

For more setup details, see the Fivetran Documentation.

Hunters.AI

34.223.20.125 , 34.223.221.217 , 52.32.222.121 , 52.35.219.75 , 52.40.78.172 , 54.68.155.124

Informatica

TBA

Matillion Data Loader

N/A

Does not work with network policies that block traffic.

Matillion ETL

N/A

Does not work with network policies that block traffic.

Qlik

N/A

Does not work with network policies that block traffic.

Rivery

13.58.140.165/32 , 34.254.56.182/32 , 52.14.86.20/32 , 52.14.192.86/32

Sigma

104.197.169.18 , 104.197.193.23

Sisense

Various

See the Sisense Documentation for the addresses.

SnapLogic

Various

See the SnapLogic Documentation for the addresses.

Stitch

Various

See the Stitch Documentation for the addresses.

Striim

TBA

SqlDBM

TBA

ThoughSpot

35.164.213.211

Zepl

34.214.146.198 , 35.164.138.115 , 52.24.205.101

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:

  1. Log into the Snowflake web interface.

  2. Click the user menu » Switch Role » ACCOUNTADMIN to change to the account administrator role.

  3. Click on Partner Connect Partner Connect tab. The Snowflake Partner Connect page opens.

  4. Click 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.

  5. Use the corresponding DROP <object> command to drop each of the objects created by the partner connection.

  6. 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.