lobbin
lobbin

Reputation: 147

Export AWS Timestream table to JSON/CSV

I need to export/dump an AWS Timestream table to CSV/JSON but I'm having trouble figuring out how to do it. Everything I find seems related to ingesting into Timestream.

I was thinking about AWS Kinesis and but I can't find any existing producers and I was hoping that I wouldn't have to write my own.

Upvotes: 3

Views: 3194

Answers (1)

lobbin
lobbin

Reputation: 147

Ended up writing a small producer. Turns out it wasn't really that huge of an effort and looking for a proper tool most likely took longer time than actually doing it. =D

Update: Completed this by moving the code into a Lambda function that runs periodically, producing to a Kinesis Stream, processed by a Kinesis Data Firehose that transforms the JSON to CSV via another Lambda and then writes the content to a S3 bucket.

Upvotes: 2

Related Questions