Redshift live data sharing among your clusters
Redshift data sharing is a feature provided by Amazon Redshift. It enables the sharing of data within and across AWS accounts, allowing different teams or users to access the same data sets for their analytics or reporting needs. Datashare reflects updates in the producer cluster in real time with the consumers ensuring that all users have access to the most up-to-date information without the need to create and maintain duplicate copies of the same data.
In this recipe, we will see how to share Redshift data between two Redshift clusters in different AWS accounts.
Getting ready
This recipe assumes that you have two encrypted Redshift clusters using Ra3 node types. Also, the tables to be shared from the producer cluster should not have interleaved sort keys. If you want to follow the recipe with clusters in the same account, you can skip the authorization and association steps. Instead, directly grant usage of the datashare to...
