Redshift Managed Storage vs Spectrum

0

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?

demandé il y a 4 ans743 vues
1 réponse
0
Réponse acceptée

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 pictureAWS
EXPERT
Rajiv_G
répondu il y a 4 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions