Amazon Timestream for LiveAnalytics will no longer be open to new customers starting June 20, 2025. If you would like to use Amazon Timestream for LiveAnalytics, sign up prior to that date. Existing customers can continue to use the service as normal. For more information, see Amazon Timestream for LiveAnalytics availability change.
Simple queries
The following gets the 10 most recently added data points for a table.
SELECT * FROM<database_name>.<table_name>ORDER BY time DESC LIMIT 10
The following gets the 5 oldest data points for a specific measure.
SELECT * FROM<database_name>.<table_name>WHERE measure_name = '<measure_name>' ORDER BY time ASC LIMIT 5
The following works with nanosecond granularity timestamps.
SELECT now() AS time_now , now() - (INTERVAL '12' HOUR) AS twelve_hour_earlier -- Compatibility with ANSI SQL , now() - 12h AS also_twelve_hour_earlier -- Convenient time interval literals , ago(12h) AS twelve_hours_ago -- More convenience with time functionality , bin(now(), 10m) AS time_binned -- Convenient time binning support , ago(50ns) AS fifty_ns_ago -- Nanosecond support , now() + (1h + 50ns) AS hour_fifty_ns_future
Measure values for multi-measure records are identified by column name. Measure values
for single-measure records are identified by
measure_value::, where
<data_type><data_type>double, bigint, boolean, or varchar
as described in Supported data types. For more information about how measure values are modeled, see Single table vs. multiple tables.
The following retrieves values for a measure called speed from
multi-measure records with a measure_name of
IoTMulti-stats.
SELECT speed FROM<database_name>.<table_name>where measure_name = 'IoTMulti-stats'
The following retrieves double values from single-measure records with a
measure_name of load.
SELECT measure_value::double FROM<database_name>.<table_name>WHERE measure_name = 'load'
