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?

gefragt vor 4 Jahren743 Aufrufe
1 Antwort
0
Akzeptierte Antwort

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
EXPERTE
Rajiv_G
beantwortet vor 4 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen