I am trying to figure out which is the best approach to build backups of a database or a table in Amazon timestream.
In the AWS documentation page you can read this:
While Amazon Timestream is multi-AZ, it does not support backups to other AWS Availability Zones or Regions. However, you can write your own application using the Timestream SDK to query data and save it to the destination of your choice.
Therefore, AWS does not help me too much in this case, since querying hourly or daily with scheduled queries and storing all the data in another table does not seem to me a very optimal option.
Has anyone faced the same problem and approached it differently? Perhaps using other AWS services and optimizing the costs generated?
Any help or suggestions are welcome.