By using AWS re:Post, you agree to the Terms of Use

Redshift Managed Storage vs Spectrum


Customer is currently using Spectrum to offload static data into S3. Is this still needed if they move to the newer RA3 instances with Redshift Managed Storage? Is there a method for ingesting S3 data into Redshift Managed Storage?

asked 2 years ago121 views
1 Answer
Accepted Answer

If the only purpose of the data to be in S3 is for access via Redshift, they can certainly switch to RA3. There is no special command to load the data. Just use a COPY statement.

However, if the data which has been offloaded to S3 is used by other processes (i.e. EMR, Athena, etc.), it will no longer be accessible by these and you should continue to use Redshift Spectrum.

profile picture
answered 2 years ago

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