Home > other >  The data copy BTWN tables
The data copy BTWN tables

Time:09-26

Oneself to carry on the dist Redshift of table key and redefine the sort key, so you need to copy the old table data into the new table, the data quantity is large, one of the table there are ten billion records, please recommend which way is the fastest?

1) create table new table AS select * from the old table;
2) unload data into S3, and then copy to the new table
  •  Tags:  
  • AWS
  • Related