Memuat ulang data yang dibongkar

Untuk memuat ulang hasil operasi membongkar, Anda dapat menggunakan perintah COPY.

Contoh berikut menunjukkan kasus sederhana di mana tabel VENUE dibongkar menggunakan file manifes, dipotong, dan reloaded.

unload  ('select * from venue order by venueid')
to 's3://mybucket/tickit/venue/reload_' 
iam_role 'arn:aws:iam::0123456789012:role/MyRedshiftRole' 
manifest 
delimiter '|';

truncate venue;

copy venue 
from 's3://mybucket/tickit/venue/reload_manifest' 
iam_role 'arn:aws:iam::0123456789012:role/MyRedshiftRole'
manifest 
delimiter '|';

Setelah dimuat ulang, tabel VENUE terlihat seperti ini:

select * from venue order by venueid limit 5;

 venueid |         venuename         |  venuecity  | venuestate | venueseats
---------+---------------------------+-------------+------------+-----------
       1 | Toyota Park               | Bridgeview  | IL         |          0
       2 | Columbus Crew Stadium     | Columbus    | OH         |          0
       3 | RFK Stadium               | Washington  | DC         |          0
       4 | CommunityAmerica Ballpark | Kansas City | KS         |          0
       5 | Gillette Stadium          | Foxborough  | MA         |      68756
(5 rows)