Write Excel from TimeStream's table

0

Hello,

I wanna write an Excel from my TimeStream's table in a cycle, it will write once a day. My idea is use Python. I saw many services such as Lambda, SDK and S3. What is the best service for this application? Any have an example or tutorial?

Thanks!

1 個回答
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.

AWS
Joerg_W
已回答 6 個月前
  • 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

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南