AWS Timestream query: How to extrapolate latest value

Question

I have a number of devices that are pushing their measured values to AWS TS only when the values has changed.   When I pull a graph of my devices history, I want to see all the values up until NOW... Which I don't have because the time series stop at the latest value that was recorded.  Is there a way to extrapolate (with a query) the value at now() based on the last value?

Accepted Answer

I solved my problem by adding the last known value at the end of the time series, before interpolating.

Answer

Timestream query does not support extrapolation. Please check https://docs.aws.amazon.com/timestream/latest/developerguide/timeseries-specific-constructs.functions.interpolation.html to see if you can use the interpolation functions to help you get the data.

AWS Timestream query: How to extrapolate latest value

Conteúdo relevante