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

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ