Updating a Rockset Collection when a file in S3 is deleted

:question: QUESTION
If we delete an s3 file, does the corresponding information on a Rockset collection get deleted as well?

:white_check_mark: ANSWER
No, it doesn’t- most customers wouldn’t want this. It is also not a good architecture design. A better way would be to create a new directory in S3, with a timestamp or date built into the path/directory name. From there, add the new file in the directory. Create a new collection based on the new directory created. When the new collection is created and loaded, change the alias over to reference the new collection. Finally, you can delete the old directory in S3 and delete the old Rockset collection.

Reference:
Rockset aliases

1 Like