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?

preguntada hace 4 años743 visualizaciones
1 Respuesta
0
Respuesta aceptada

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
EXPERTO
Rajiv_G
respondido hace 4 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas