Set Up a Snowflake Data Federation Connection
Set up a connection between Snowflake and Data Cloud to access the data.
| User Permissions Needed | |
|---|---|
| To create a Snowflake Data Federation connection in Data Cloud. | System Admin |
Before you begin:
- For Private Connect for Data Cloud, you must configure a network route to create a connection to Snowflake.
- For connections that don’t use Private Connect for Data Cloud:
- Review Data Cloud IP Allowlist and update your allowlists.
- Get the Snowflake credentials and private key from Snowflake admin. See Key-pair authentication and rotation.
- To support large data sizes contact Snowflake admin and increase the security token expiry time in Snowflake to 24 hours.
You can’t use an existing connection and change it to use Private Connect. This isn’t supported.
-
In Data Cloud, go to Data Cloud Setup.
-
Under External Integrations, select Snowflake.
-
Click New.
-
Enter a connection name and connection API name.
-
For Private Connect for Data Cloud:
-
Click Use Private Network Route.
-
Select the private network route for the Snowflake instance. The list of routes are only for private network routes to Snowflake.
-
-
For connections that don’t use Private Connect for Data Cloud, enter the account URL.
-
Enter the username for the Snowflake account.
-
Enter the private key details.
You can’t use an encrypted private key. When you enter the key, don’t include BEGIN PRIVATE KEY at the start of the key and END PRIVATE KEY at the end.
-
Click Next.
-
Select a database, and click Save.