Hi,
I have what I think is a pretty common use case, whereby I'd like to keep "hot" data in my Timestream table memory store for 30 days before moving this to "colder" magnetic storage for keeping for 12 months (all good so far).
After the 12 months is up however, I don't want this data to be simply deleted from the magnetic store, but instead would like to automatically move this data to S3 for long-term archiving in an effort to stop my Timestream table growing indefinitely (primarily as a cost optimisation measure).
What is the recommended way of achieving this? (I note that TimescaleDB does this "automatically" already).
could you let me know if I am using UNLOAD to export results to S3. will it be called moving the data or copying the data. in order to save the storage cost of Timestream I want to archive its data not copy.