About Salesforce Data Cloud and Snowflake¶

Snowflake and Salesforce have partnered to offer customers a seamless zero-copy integration between Salesforce Data Cloud and Snowflake. The integration enables customers to access semantically rich Salesforce data products directly from their existing Snowflake accounts, without ETL pipelines, data replication, or moving data out of Salesforce.

Leveraging zero-copy data access, data and AI teams can work with real-time Salesforce customer, engagement, and business data in Snowflake, building analytics, machine learning models, and AI applications grounded in the full context of their mission-critical Salesforce data.

How it works¶

Salesforce Data Cloud shares data products with your Snowflake account through a Zerocopy Connector. The connector establishes a secure, authenticated channel between Salesforce Data Cloud and your Snowflake account. Once connected, Salesforce data products appear in Snowflake as catalog-linked databases, which are native Snowflake database objects that expose the shared data for querying without copying it.

Data stays in Salesforce. Snowflake queries it on demand. There is no ETL and no duplication.

Integration for existing Snowflake customers¶

The Salesforce Data Cloud Zero-Copy integration is designed for existing Snowflake customers who want to bring Salesforce data products into their Snowflake account. Unlike some partner integrations, there is no greenfield (new account provisioning) path: you use your existing Snowflake account.

As a Snowflake account administrator, you create a Zerocopy Connector in your account and retrieve an Enrollment ID. You then provide that Enrollment ID to your Salesforce administrator, who creates a Data Share Target in Salesforce Data Cloud to authorize the connection. Once connected, Salesforce administrators can share data products from the Salesforce Data Cloud catalog with your connector, and you can immediately query them in Snowflake.

Prerequisites¶

Before starting, ensure:

• You have an existing Snowflake account (Standard, Enterprise, or Business Critical edition).
• Your Snowflake account is in a supported region. For details, see Supported Cloud Regions.
• Your Salesforce administrator has access to Salesforce Data Cloud and can provision a connector and share data products.

Set up the integration¶

Perform the following tasks in order to set up, configure, and run the Salesforce Data Cloud Zero-Copy integration.