The process for configuring a Snowflake connection is identical, regardless of the cloud platform on which Snowflake is running.
- Google Cloud
Connecting to your Snowflake environment requires a user that has read privileges for using training data and apply data. If you want to write predictions to Snowflake, the user needs drop, create, read and write access to the Snowflake table(s) where predictions will be written.
If your Snowflake database is not accessible outside of your network, you may need to contact your IT department to whitelist the necessary IP address. Please contact your friendly neighborhood Customer Success Manager for more information.
Adding a New Snowflake Connection
- Log in
- Click the "hamburger menu" in the upper left
- Click on "Manage Data"
- Click on the Snowflake data provider card and enter your credentials, then click "CONNECT"
Account: Specifies the portion of the account specific to your Snowflake environment. Do not include "https://" prefix or ".snowflakecomputing.com" suffix since these are automatically added when establishing the connection.
AWS example: abcdefg-mycompany_myregion
If your Snowflake environment is in the AWS US West region, you do need to specify the region (e.g. abcdefg-mycompany)
Username: Specifies the login name of the Snowflake user to authenticate
Password: Specifies the password of the user that is connecting to Snowflake
Database: Specifies the default database to use.
Schema: Specifies the default schema to use.
Warehouse: Specifies the default warehouse to use to run queries
Role: (OPTIONAL) Specifies the role to use with the associated username.
Legacy Video: Snowflake Integration Overview
- Instructional overview of connecting to Snowflake
- Information on pulling training and apply data from Snowflake
- Explanation of how to synchronize predictions to Snowflake
- A brief overview of Automated Prediction Download functionality