Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 681
lobbin Avatar asked Feb 11 '26 12:02

lobbin


1 Answers

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.

like image 168
lobbin Avatar answered Feb 15 '26 11:02

lobbin



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!