1 Answer
- Newest
- Most votes
- Most comments
0
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.
answered 3 years ago
Relevant content
- asked 2 years ago
- asked 2 days ago
- Accepted Answerasked 2 months ago
- asked 9 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
Is this still accurate, https://docs.aws.amazon.com/redshift/latest/dg/cluster-mgmt.html states that when a cluster is paused the share is still available and in fact other resources state the caching continues to be maintained.