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: https://###-west-1.amazonaws.com/###/###/###.csv

主題

儲存空間分析

標籤

Amazon Simple Storage Service Amazon Redshift

語言

English

AWS-User-8801280

已提問 2 年前檢視次數 1051 次

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.

專家

Behram

已回答 2 年前

Fabrizio@AWS 專家
2 年前
You can, also , use the query editor V2 to generate the Copy command for you and load the data in your table, as shown in this video: https://www.youtube.com/watch?v=NWKS8teMmVw

Redshift Insert into s3 file data into existing table

相關內容