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).