You can read data from tables enabled for data sharing in Amazon Redshift. Data sharing allows you to share data across Amazon Redshift clusters without the need to copy or move the data or duplicate the storage.
Amazon Redshift data sharing includes the following components:
•Producer cluster. The Amazon Redshift cluster that owns the data and shares it with other clusters.
•Consumer cluster. The Amazon Redshift cluster that receives and accesses the shared data from a producer cluster.
•Datashare. A logical unit of sharing created on the producer cluster and contains the specific database objects to be shared.
To use data sharing, specify the database name of the consumer cluster in the JDBC URL when you create an Amazon Redshift V2 connection.