Posted On: May 15, 2023

Amazon Timestream now enables you to export your query results to Amazon S3 in a cost-effective and secure manner using the new UNLOAD statement.

Using the UNLOAD statement, you can now export query results to a selected S3 bucket in either the Apache Parquet or Comma Separated Values (CSV) format, which provides flexibility to store, combine, and analyze your time series data using other services. The UNLOAD statement allows you to export the data in a compressed manner and also partition the data based on selected attributes, which reduces the storage space required and processing time for downstream services accessing the data. In addition, you can encrypt your exported data using Amazon S3 managed keys (SSE-S3) or AWS Key Management Service (AWS KMS) managed keys (SSE-KMS), preventing unauthorized access. 

You can now export gigabytes of data in a single query request in the supported formats, which enables you to more easily build data lakes and combine with non-time series data to derive complex business insights. You can execute an UNLOAD statement using the Timestream console, API, or CLI and the functionality is available in all AWS Regions where Timestream is available, listed here.

Amazon Timestream is a fast, scalable, secure, and purpose-built time series database for application monitoring, edge, and IoT workloads that can scale to process trillions of time series events per day. To get started with Timestream, visit the product page. To learn more about the UNLOAD statement and get started, see documentation.