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 Resposta
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
respondido há 6 meses
  • 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

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas