Publish and query your Redshift system logs off-cluster.
Recent revisions are kept. Restoring one creates a new revision.