Posted On: Feb 10, 2021

Amazon Timestream has added new capabilities to its SQL query language to enable customers to gain deeper insights from their time series data by running cross table queries and queries with advanced time series functions. Starting today, customers can also gain more transparency into the query execution statistics, to better understand the cost and duration of a running query. Lastly, the implementation of Amazon Timestream’s JDBC Driver is now available under the Apache 2.0 License on GitHub, so customers can contribute new features and enhancements to the JDBC driver.

To better understand trends and patterns across time series data, identify the rate at which the data changes over time, and recognize the degree of similarity between related data, customers can now run SQL queries with advanced time series functions such as derivatives, integrals, and correlations, and queries with joins and unions across multiple tables. Additionally, customers now have access to the amount of data scanned by a query, so they can estimate the cost of queries. They can also identify how far along a query is in its execution process, so they can identify and/or cancel long running queries. These query statistics are available as part of the Query API and can also be accessed through the AWS Management Console for Amazon Timestream.

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 up to 1,000 times faster than relational databases, and at as low as 1/10th the cost. Amazon Timestream is also HIPAA eligible, ISO certified, and PCI DSS compliant. The service is currently available in US East (N. Virginia), US East (Ohio), US West (Oregon), and EU (Ireland), with availability in additional regions in the coming months. To get started with Amazon Timestream, visit our product page.