Question

A retail analytics company runs a production Amazon Redshift RA3 cluster that holds curated sales data. A separate data science team has its own Redshift RA3 cluster and needs read-only access to the latest curated sales tables for machine learning feature engineering. The data must always reflect the producer cluster's current state without copying, and the producer team wants to avoid ETL jobs or scheduled unloads. Which approach best meets these requirements?

Accepted Answer

Configure Amazon Redshift data sharing, creating a datashare on the producer cluster and granting the consumer cluster access to the sales tables.

Answer

Schedule a nightly UNLOAD from the producer cluster to Amazon S3 and use COPY to load the data into the consumer cluster.

Answer

Create a Redshift Spectrum external schema on the consumer cluster pointing to the producer cluster's local tables.

Answer

Take a snapshot of the producer cluster and restore it into the consumer cluster's namespace each morning.