Does UNLOAD command removes or deletes data from redshift?

2
votes

I want to copy table data from redshift to S3; but keep original data in redshift. I know there is UNLOAD command for that purpose. But I am not sure if it deletes/removes data from original table. Does somebody have solution?

1
amazon-web-servicesamazon-s3amazon-redshift

1 Answers

8
votes

Unload does not delete or remove data from the original table. See the explicit truncate in the COPY reload example