Question: how to copy data from one table to another redshift?
Answer: 2 Answers. You can do insert into new_table ( select * from old_table ) . But for bigger tables you should always do unload from old table then copy to new table. The copy commands load data in parallel and it works fast.