user2137216
user2137216

Reputation: 79

Does UNLOAD command removes or deletes data from redshift?

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

Answers (1)

DogBoneBlues
DogBoneBlues

Reputation: 392

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

Upvotes: 8

Related Questions