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


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 ?

asked 3 months ago237 views
1 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.

answered 3 months ago
  • Is it possible to directly access data from a manually created snapshot ?

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