Question

A financial services company runs a provisioned Amazon Redshift cluster that holds curated transaction data. A separate business unit within the same AWS account operates its own Redshift Serverless workgroup and needs read-only access to the latest version of several curated tables for ad hoc analytics. The data changes throughout the day, and the business unit must always see current data without any ETL copying or scheduled refresh jobs. Which approach meets these requirements with the least operational overhead?

Accepted Answer

Create a Redshift datashare on the producer cluster that includes the curated tables, and grant the Serverless workgroup access as a consumer.

Answer

Schedule an hourly UNLOAD of the tables to Amazon S3 and have the Serverless workgroup query them with Redshift Spectrum external tables.

Answer

Set up an AWS Glue ETL job to copy the tables into the Serverless workgroup's storage every 15 minutes.

Answer

Enable cross-database queries so the Serverless workgroup can query the producer cluster's local databases directly.