By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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!

Topics
StorageInternet of Things (IoT)ServerlessComputeDatabase
Tags
Amazon S3 GlacierAWS IoT CoreAWS LambdaAmazon TimestreamAmazon Chime SDK
Language
English
Lunuel0
asked a year ago317 views
1 Answer
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
answered a year ago
  • Lunuel0
    a year ago

    Timestream --> S3 --> LAMBDA --> Excel . Right? Can i write excel without S3? or is mandatory? Thanks for reply

  • Joerg_W
    a year ago

    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?

  • Viktor
    8 months ago

    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

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content