By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

AWS Timestream query: How to extrapolate latest value

0

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?

Topics
Database
Tags
Amazon Timestream
Language
English
AWS-User-8812558
asked 2 years ago246 views
2 Answers
0
Accepted Answer

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

AWS-User-8812558
answered 2 years ago
0

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
Rajesh Iyer - AWS
answered 2 years ago
profile picture
EXPERT
Giovanni Lauria
reviewed 21 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content