1 Answer
- Newest
- Most votes
- Most comments
1
Have you had a look at the UNLOAD command? It allows you to export your data to, for example, a CSV file on S3. For an example of how to trigger this from Python see https://docs.aws.amazon.com/timestream/latest/developerguide/code-samples.run-query-unload.html.
You could then create a Lambda function, which gets triggered once a day and calls the UNLOAD command as explained above.
answered 5 months ago
Relevant content
AWS OFFICIALUpdated 3 years ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
Timestream --> S3 --> LAMBDA --> Excel . Right? Can i write excel without S3? or is mandatory? Thanks for reply
if you want it to be triggered once a day, where would you want to store the data or how would you want to download it?
Indeed. CSV file might be easily opened in excel. But there is one unclear stuff: UNLOAD might create multiple files even if data amount is less than max_file_size