Snowflake
Snowflake
Follow these steps to connect Snowflake to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud 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.
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 Cloud 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 Cloud 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 Cloud 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 Cloud 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 Cloud 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 Cloud static IP addresses to your connection whitelist.
More Information
For more information about interactions between CData Connect Cloud and Snowflake, see this information page.