QuestionQ79

VerifiedData Store Management

A company operates an Amazon Redshift provisioned cluster for extract, transform, and load (ETL) operations that support critical analysis tasks. A sales team in the company operates a Redshift cluster for business intelligence (BI) tasks.

The sales team has recently requested access to the data in the ETL Redshift cluster to perform weekly summary analysis. The team must join data from the ETL cluster with data in the sales team's BI cluster.

The company needs a solution that shares the ETL cluster data with the sales team without disrupting the critical analysis tasks. The solution must minimize use of the ETL cluster's compute resources.

Which solution meets these requirements?

Explanation

Amazon Redshift data sharing securely exposes live producer-cluster data to a consumer cluster without copying or transferring it. The sales BI cluster can consume the ETL cluster’s datashare and join shared data with its local data, with the consumer cluster handling query compute and thereby isolating the ETL workload.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!