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?

feita há 4 anos743 visualizações
1 Resposta
0
Resposta aceita

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
ESPECIALISTA
Rajiv_G
respondido há 4 anos

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas