Queries - Amazon Timestream

Queries

  • Include only the measure and dimension names essential to query. Adding extraneous columns will increase data scans, which impacts the performance of queries

  • Where possible, push the data computation to Timestream using the built-in aggregates and scalar functions in the SELECT clause and WHERE clause as applicable to improve query performance and reduce cost

  • Where possible, use approximate functions. E.g., use APPROX_DISTINCT instead of COUNT(DISTINCT column_name) to optimize query performance and reduce the query cost

  • Use a CASE expression to perform complex aggregations instead of selecting from the same table multiple times

  • Where possible, include a time range in the WHERE clause of your query. This optimizes query performance and costs. For example, if you only need the last one hour of data in your dataset, then include a time predicate such as time > ago(1h)

  • When a query accesses a subset of measures in a table, always include the measure names in the WHERE clause of the query

  • Where possible, use the equality operator when comparing dimensions and measures in the WHERE clause of a query. An equality predicate on dimensions and measure names allows for improved query performance and reduced query costs

  • Wherever possible, avoid using functions in the WHERE clause to optimize for cost

  • Refrain from using LIKE clause multiple times. Rather, use regular expressions when you are filtering for multiple values on a string column

  • Only use the necessary columns in the GROUP BY clause of a query

  • If the query result needs to be in a specific order, explicitly specify that order in the ORDER BY clause of the outermost query. If your query result does not require ordering, avoid using an ORDER BY clause to improve query performance

  • Use a LIMIT clause if you only need the first N rows in your query

  • If you are using an ORDER BY clause to look at the top or bottom N values, use a LIMIT clause to reduce the query costs

  • Use the pagination token from the returned response to retrieve the query results. Refer to the Query API documentation for more information

  • If you've started running a query and realize that the query will not return the results you're looking for, cancel the query to save cost

  • If your application experiences throttling, continue sending data to Amazon Timestream at the same rate to enable Amazon Timestream to auto-scale to the satisfy the query throughput needs of your application

  • If the query concurrency requirements of your applications exceed the default limits of Timestream, contact AWS Support for limit increases