By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

Topics
StorageAnalytics
Tags
Amazon Simple Storage ServiceAmazon Redshift
Language
English
AWS-User-8801280
asked 3 years ago1.3K views
1 Answer
1

Easiest way is to use COPY command. Details and examples are [here] (https://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html).

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.

AWS
EXPERT
Behram
answered 3 years 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

Relevant content