Redshift Data Sharing - Play and Pause


Is there any change in "Play and Pause" functionality and costs for compute redshift clusters that are sharing data or using shared data in "Redshift data sharing feature"?

For example,

  • Cluster A (RA3) shares data with cluster B (DC2) and Cluster C (RA3).
  • Cluster A is only crunching data during off-office hours and is paused during business hours.
  • Cluster A shares data (not all) with Cluster B and Cluster C
  • Cluster B and C are paused during off-office hours and are active only during business hours

So, the question is how Cluster A, Cluster B and Cluster C are charged?

PS: I know I can use cluster A during business hours and save with RI but just assume here I cannot use cluster A because cluster A, B and C belong to different Line of Business.

asked 4 years ago848 views
1 Answer
Accepted Answer

Hello Vikas, at reInvent 2020, Redshift released a feature called live data sharing across clusters. Currently this feature is in preview and works for the RA3 family of clusters. The producer cluster stores all the data and shares the desired data to the consumer clusters.

The producer cluster pays for the storage for the share (obviously) and the consumer will pay for the compute as and when it tries to query the share.

This is a live feature, which means as soon as there is a DDL / DML change in the producer cluster is reflected in the consumer right away. If the producer is down for some reason such as maintenance / paused then this feature will not work.

Have a look at the resources below for further reading.

  1. Amazon Redshift data sharing workflow
  2. Amazon Redshift data sharing use cases
  3. AWS on Air 2020: Amazon Redshift Data Sharing and Isolation
  4. Announcing Amazon Redshift data sharing (preview)
  5. Sharing Amazon Redshift data securely across Amazon Redshift clusters for workload isolation
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions