CODEWITHSUNDEEP
amazon-redshift
dinesh707
dinesh707

Reputation: 12582

Can I copy from one table to another in Redshift

I understand that the COPY command imports lots of data very efficiently. But copying data from one table to another with the INSERT command is slow. Is there a more efficient way to copy data from one table to the other? Or should I use the UNLOAD command to unload the table into S3, then COPY it back from there?

Upvotes: 11

Views: 22857

Answers (2)

Sandesh Deshmane
Sandesh Deshmane

Reputation: 2305

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. Unload also unloads data parallel. So unload and copy is good option to copy data from one table to other.

when you do copy command it automatically do the encoding ( compression ) for your data. When you do insert into ( select * from ) it will not do compression/encoding. You need to explicitly apply encoding types when you create new table.

Upvotes: 16

Nadimuthu Sarangapani
Nadimuthu Sarangapani

Reputation: 316

If you want to copy the records from source_table to target_table. Then query must be below

insert into target_table select * from source_table

Upvotes: 4

Related Questions