Reputation: 79
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?
Upvotes: 3
Views: 2490
Reputation: 392
Unload does not delete or remove data from the original table. See the explicit truncate in the COPY reload example
Upvotes: 8