Home icon

Harness Zero Copy data sharing from Salesforce Data Cloud to Amazon Redshift for Unified Analytics – Part 1

Big Data Blog



This article discusses how to leverage Zero Copy data sharing to allow Amazon Redshift to query customer 360 data from Salesforce Data Cloud without needing to extract, transform, and load (ETL) the data. It covers the benefits, architecture, and steps involved in setting up bidirectional data sharing between Salesforce Data Cloud and Amazon Redshift for unified analytics.

Specifically, the article covers:

  • What is Salesforce Data Cloud and Amazon Redshift
  • Overview of Zero Copy data sharing
  • Solution architecture for data sharing between Salesforce Data Cloud and Amazon Redshift in the same AWS Region
  • Prerequisites for enabling data sharing
  • Step-by-step process to create a data share target, data share, and link them in Salesforce Data Cloud
  • Accepting the data share and creating a resource link in AWS Lake Formation
  • Querying the shared data from Redshift Serverless and provisioned clusters
  • Conclusion highlighting the benefits of this integration


Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Sep 12
2024
Harness Zero Copy data sharing from Salesforce Data Cloud to Amazon Redshift for Unified Analytics – Part 2
Jun 25
2024
Access Amazon Redshift data from Salesforce Data Cloud with Zero Copy Data Federation
Sep 10
2024
Evaluating sample Amazon Redshift data sharing architecture using Redshift Test Drive and advanced SQL analysis
Aug 8
2025
Simplify data integration using zero-ETL from Amazon RDS to Amazon Redshift

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.