Snowflake
Snowflake
Prerequisites
Whitelist CData IPs
To establish a connection to Snowflake, you need to allow access to Snowflake via CData’s IP. When hosting Snowflake behind a firewall, you must safelist these IP addresses in your firewall.
-
Range:
52.224.0.160
to52.224.0.175
-
CIDR notation:
52.224.0.160/28
Ensure Snowflake is Publicly Accessible
Provide a public facing IP/domain to connect to this data source. The following private IP ranges do not work:
-
10.0.0.0
to10.255.255.255
-
172.16.0.0
to172.31.255.255
-
192.168.0.0
to192.168.255.255
-
127.0.0.1
(aka ‘localhost’)
Setup Guide
Follow these steps to connect Snowflake to your CData Connect account:
-
Open the Connections page of the CData Connect dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Snowflake into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the following information:
-
Warehouse—the name of the Snowflake warehouse
-
URL—the URL of the Snowflake database
-
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
Authentication Methods
Password
-
Enter your user name in the User field and password in the Password field.
-
In the Database section, enter the name of the Snowflake database to connect to.
-
(Optional) Enter the schemas of the Snowflake database to connect to. If this is left blank, the connector has access to all schemas in the database.
-
At the top of the CData Connect Add Snowflake Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
-
In Snowflake, add the CData Connect static IP addresses to your connection whitelist.
Private Key
Follow these steps to configure private key authentication:
-
Open your Snowflake keyfile (which ends in .p8) in a text editor.
-
Copy the entire contents of the file.
-
Enter the copied contents of your private key into the Private Key field.
-
If your private key has a password, enter it in the Private Key Password field.
-
Select the correct Private Key Type from the drop down.
-
In the Database section, enter the name of the Snowflake database to connect to.
-
(Optional) Enter the schemas of the Snowflake database to connect to. If this is left blank, the connector has access to all schemas in the database.
-
At the top of the CData Connect Add Snowflake Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
-
In Snowflake, add the CData Connect static IP addresses to your connection whitelist.
Okta
-
Enter the following information:
-
User— The Okta user account.
-
Password— The password associated with the Okta account.
-
MFA Passcode— Set this to the OTP code that was sent to your device. This property should be used only when Multi-Factor Authentication is required for Okta sign on.
-
SSO Properties— are needed to authenticate to Okta:
- Domain: Set this to the OKTA org domain name.
- MFAType (optional): Set this to the multi-factor type. This property should be used only when the MFA is required for Okta sign on. This property accepts one of the following values:
- OKTAVerify
- SMS
- APIToken (optional): Set this to the API Token created by Okta. This is used when authenticating a user via a trusted application or proxy that overrides the Okta client request context.
-
-
In the Database section, enter the name of the Snowflake database to connect to.
-
(Optional) Enter the schemas of the Snowflake database to connect to. If this is left blank, the connector has access to all schemas in the database.
-
At the top of the CData Connect Add Snowflake Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
-
In Snowflake, add the CData Connect static IP addresses to your connection whitelist.
More Information
For more information about interactions between CData Connect and Snowflake, see this information page.