Is it possible to access the raw data inside a snapshot in redshift ?

Question

My redshift cluster has automatic snapshots which are being created. Is there a way for me to access the incremental data to the cluster ? I do not want to restore the cluster, I want incremental data across snapshots if it is possible ?

Can we read raw data from a individual snapshot using a api or sdk or a sql query ?

Answer

It is currently not possible to directly access the automated snapshots other than restoring them to a provisioned cluster or serverless endpoint. If you need to access the automated snapshots for adhoc purposes, I would recommend restoring to a serverless namespace and then querying it as needed.

https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-migration.html

Is it possible to access the raw data inside a snapshot in redshift ?

Conteúdo relevante