Redshift Insert into s3 file data into existing table


In Redshift, How do I insert into an existing table (table name: 'container_tv') from this s3 file:

asked a year ago469 views
1 Answer

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.

answered a year 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