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.
Redshift data warehouse and Glue ETL design recommendationsAccepted Answerasked 2 years ago
Redshift varchar(max) not enough to store json data type column from Postgresasked 7 months ago
Loading json string data as super from Glue job in to Redshiftasked 9 months ago
How do you build a BI semantic layer using Amazon Redshift?Accepted Answerasked 2 years ago
Redshift Data API not recognized by Boto3Accepted Answerasked 2 years ago
Does the Amazon Redshift pause and resume functionality also work with DS2 clusters?Accepted Answerasked 3 years ago
use Redshift Spectrum to query both Redshift table and s3 fileAccepted Answerasked 2 years ago
Using redshift-data boto3 to make cross account redshift callsasked 8 months ago
Redshift Data Sharing - Play and PauseAccepted Answerasked 2 years ago
Distinguish Redshift Spectrum from Redshift CostsAccepted Answerasked 4 years ago