Amazon Redshift Data Sharing - Underlying Technology

Abdul R. Wahab
2 min readMay 8


Source: Abdul R. Wahab

The diagram above shows how the Redshift Data Share feature enables you to share data across Redshift clusters in different AWS accounts.

Here’s how it works:

  1. Redshift data share creates a shared VPC endpoint in the producer account that acts as a gateway for the consumer account to access the producer Redshift cluster.
  2. The producer account shares a specific set of data (tables) with the consumer account using a data share. At its core, a data share is a virtual object that defines the data that can be accessed by the consumer account.
  3. The consumer account creates an external schema in their Redshift cluster using Redshift Spectrum. The external schema is configured to use the shared VPC endpoint in the producer account as the data source.
  4. The external schema allows the consumer account to access the shared data in the producer Redshift cluster without copying the data or replicating the data into the consumer account’s data stores.


The shared data remains stored in the producer account’s data store, and the consumer account only accesses the data through the shared VPC endpoint and external schema.

This provides a secure and efficient way to share data between Redshift clusters in different AWS accounts.

Related reading

Check out my list below of other Redshift and AWS Data-related topics! ⬇️

Data + Cloud (Redshift, Data Mesh)

17 stories



AWS Redshift - INSERT & COPY Commands

2 min read

Jun 4

A Deep Dive into AWS Data Services

7 min read

May 29

AWS Redshift - Cross-Account Unload & Copy with S3

3 min read

May 26

AWS Data Integration across Multiple Data Stores

4 min read

May 7

Authenticating to AWS Redshift using Ephemeral Credentials

3 min read

Apr 29

Amazon Redshift  —  Overview

7 min read

Oct 17, 2021

Amazon Redshift: Data Consumption Patterns - Part I

3 min read

Apr 16

AWS Redshift Data sharing: Cluster-to-Cluster / Sharing to a Unified Cluster

4 min read

Apr 23

Amazon Redshift - Views: Simple, Materialized, Late-Binding

3 min read

Apr 27

Lesser Known aspects of Amazon Redshift

4 min read

Apr 28

Abdul R. Wahab

Tech guy. I like building cool software, & also leading others in building cool things. All views shared are my own.

Recommended from Medium


See more recommendations