1 Answer
- Newest
- Most votes
- Most comments
1
Hi,
Amazon Timestream now enables you to export your query results to Amazon S3 in a cost-effective and secure way using the UNLOAD statement. Using the UNLOAD statement, you can now export time series data to selected S3 buckets in either Apache Parquet or Comma Separated Values (CSV) format.
Can you explore UNLOAD from this documentation to check if this suits your requirement
answered 6 months ago
Relevant content
- asked 5 months ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated a year ago
Thank you! That was very helpful and I was able to download all the data. Do you also know, which steps are required to load this exported csv file(s) back into a (new) AWS Timestream table? Because I would like to do some modifications to the exported data like removing one column and make changes to some values and then load it back into a new database.
With batch load for Amazon Timestream, you can ingest CSV files stored in Amazon S3 into Timestream in batches.
Please explore
https://docs.aws.amazon.com/timestream/latest/developerguide/batch-load.html
https://docs.aws.amazon.com/timestream/latest/developerguide/batch-load-preparing-data-file.html