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