By using AWS re:Post, you agree to the Terms of Use
/Redshift Insert into s3 file data into existing table/

Redshift Insert into s3 file data into existing table

0

In Redshift, How do I insert into an existing table (table name: 'container_tv') from this s3 file: https://###-west-1.amazonaws.com/###/###/###.csv

1 Answers
1

Easiest way is to use COPY command. Details and examples are here.

Alternately, you create an external table using Redshift Spectrum and then use 'Insert Into Select from' in Redshift to load this external table data into Redshift core table.

EXPERT
answered a month 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