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 various 3rd-party tools and services, and then adopting the ones that best meet your business needs.
Supported Partners¶
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.
Currently, Partner Connect includes the following partners:
Partner |
Category |
Notes |
---|---|---|
(https://alation.com/) |
||
(https://www.alteryx.com) |
||
(https://www.alteryx.com) |
Alteryx Designer Cloud |
|
(https://www.altr.com/) |
Free forever plan |
|
(https://www.ascend.io/) |
||
(https://carto.com/) |
||
(https://www.cdata.com/) |
||
(https://www.getcensus.com/) |
||
(https://coalesce.io/) |
||
(https://www.datarobot.com/) |
||
(https://data.world/) |
||
(https://www.dataiku.com/dss/editions/) |
||
(https://www.dataops.live/) |
||
(https://www.getdbt.com/) |
dbt Cloud |
|
(https://www.domo.com/) |
||
(https://etleap.com/) |
||
(https://www.fivetran.com) |
||
(https://www.h2o.ai/) |
||
(https://hevodata.com/) |
Hevo Data CDC for ETL |
|
(https://hex.tech/) |
||
(https://hightouch.com/) |
||
(https://hunters.ai/) |
||
(https://www.informatica.com) |
Informatica Cloud |
|
(https://marketplace.informatica.com/forms/data-loader.html) |
Informatica Data Loader |
|
(http://www.keboola.com/) |
||
(https://knoema.com/) |
||
(https://www.matillion.com/products/data-loader/) |
Matillion Data Productivity Cloud |
|
(https://www.matillion.com/products/etl-software/) |
Matillion ETL |
|
(https://www.nexla.com/) |
||
(http://www.qlik.com/) |
Qlik Replicate |
|
(https://rivery.io/) |
||
(https://sigmacomputing.com/) |
||
(https://www.sisense.com/) |
Sisense for Cloud Data Teams |
|
(https://www.snaplogic.com/) |
||
(https://sqldbm.com/Home/) |
||
(https://www.stitchdata.com/) |
||
(https://streamsets.com/) |
||
(https://www.striim.com/) |
||
(https://www.talend.com) |
||
(https://www.thoughtspot.com/) |
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:
- Snowsight:
In some cases, you automatically receive an email prompting you to Please Validate Your Email. If you did not, follow these steps to verify your email address:
Sign in to Snowsight.
Select your username, and then select Profile
Configure your email address:
If you do not have an email address listed, enter an email address in the Email field, and then select Save.
If you cannot 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 did not receive an email, select Resend verification email. Snowflake sends a verification email to the address listed.
Open your email, and then select the link in the email to validate your email address.
- Classic Console:
Select the dropdown menu next to your login name » Preferences » General.
In the User Information area, add or verify your email address by selecting the appropriate link(s) in the Email Address field.
Connecting with a Snowflake Partner¶
To initiate a trial account with any Snowflake partner currently in Partner Connect:
Log into either Snowsight or the Classic Console.
Make ACCOUNTADMIN the active role in the interface:
- Either Interface:
Click the dropdown menu next to your login name, then click Switch Role » ACCOUNTADMIN to change to the account administrator role.
Open the Partner Connect page:
Click on the corresponding tile for the partner to which you wish to connect.
A dialog displays the requirements for connecting to the partner, as well as a list of the objects automatically created in Snowflake during the connection process, including an empty database, warehouse, default user, and custom role. The partner application uses these objects when reading from or writing to your account.
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.
If you do not specify any databases during the initial connection process, you can specify them later; however, specifying them later is a manual task.
Attention
Currently, you cannot use the Classic Console to specify shared databases (i.e. databases shared from provider accounts to your account) for your Partner Connect trial during the initial connection process. If you select a shared database, the Classic Console returns an error when you click the Connect button to complete the process.
To use shared databases with a trial:
Use Snowsight to complete the initial connection process.
Manually specify the shared database after the process completes.
Click the Connect button below the partner description to initiate creating a trial account with the partner and connecting the partner application to Snowflake.
When the process is complete and the objects have been created, the partner tile is updated with a checkmark.
Objects Created for the Partner¶
During the connection process, the following Snowflake objects for the partner application are created in your account:
Object Name |
Type |
Notes |
---|---|---|
PC_<partner>_DB |
Database |
This 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>_WH |
Warehouse |
The default size of the warehouse is X-Small, but can be changed if needed. |
PC_<partner>_USER |
System User |
This 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>_ROLE |
Role |
The 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. |
In addition, if you optionally chose to specify one or more existing databases during the initial connection process, a second custom role is created with all of the necessary privileges to access the tables in the databases:
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.
Note that this second role is not displayed in the dialog, but the role is created automatically after all the other objects listed in the dialog are created.
Tip
The above objects are created to enable a quick, convenient setup:
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.
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 PC_<partner>_WH warehouse to avoid unexpected Snowflake credit usage by the application.
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 a network policy.
The following table lists the IP addresses to add for each partner (if available and supported) or provides links to pages on the partner sites for this information:
Partner |
IP Addresses |
Notes |
---|---|---|
Alation |
N/A |
|
Alteryx |
|
|
ALTR |
|
|
Ascend.io |
N/A |
|
CARTO |
N/A |
|
CData Software |
TBD |
|
Census |
N/A |
|
Coalesce |
N/A |
|
data.world |
|
|
Dataiku |
N/A |
|
DataOps.live |
N/A |
|
DataRobot |
TBD |
|
dbt Labs |
|
|
Domo |
N/A |
|
Etleap |
N/A |
|
Fivetran |
|
For more setup details, see the Fivetran Documentation (https://fivetran.com/docs/warehouses/snowflake). |
H2O.ai |
N/A |
|
Hunters |
|
|
Hevo Data CDC for ETL |
TBD |
|
Hex |
N/A |
|
Hightouch |
N/A |
|
Informatica |
N/A |
|
Informatica Data Loader |
N/A |
|
Keboola |
N/A |
|
Knoema |
N/A |
|
Matillion Data Productivity Cloud |
N/A |
|
Matillion ETL |
N/A |
|
Nexla |
|
|
Qlik |
N/A |
|
Rivery |
|
|
Sigma |
|
|
Sisense |
Various |
For the IP addresses, see the Sisense Documentation (https://dtdocs.sisense.com/article/connecting-to-periscope-menu). |
SnapLogic |
Various |
For the IP addresses, see the SnapLogic Documentation (https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439269/Network+Setup#NetworkSetup-IPAddressWhitelisting). |
SqlDBM |
N/A |
|
Stitch |
Various |
For the IP addresses, see the Stitch Documentation (https://www.stitchdata.com/docs/destinations/snowflake/connecting-a-snowflake-data-warehouse-to-stitch#setup-requirements). |
StreamSets |
N/A |
|
Striim |
N/A |
|
Talend |
N/A |
|
ThoughtSpot |
|
Launching a Partner Application¶
After a partner application is connected to Snowflake:
On the Snowflake Partner Connect page, click the corresponding tile.
Click the Launch button to open the partner 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 either Snowsight or the Classic Console.
Make ACCOUNTADMIN the active role in the interface.
- Either Interface:
Click the dropdown menu next to your login name, then click Switch Role » ACCOUNTADMIN to change to the account administrator role.
Open the Partner Connect page:
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.
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.
Contact Snowflake Support to clear the partner connection and remove the checkmark from the partner tile in Partner Connect.
If the trial does not expire on its own, contact the partner to end your participation in the trial.
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.