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 Antwort
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
beantwortet vor 6 Monaten
  • 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

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen