Set Up a Snowflake Data Federation Connection
Set up a connection between Snowflake and Data Cloud to access the data. To set up a Snowflake data federation connection for Data Cloud, see Private Connect for Data Cloud.
| User Permissions Needed | |
|---|---|
| To create a Snowflake Data Federation connection in Data Cloud. | System Admin |
Before you begin:
- 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.
-
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.
See Also