Data not always loading and lines rendering strange - AWS timestream

Grafana
1

I’m reading data from AWS timestream, but the data seems not to be loading consistently. Graphs are not showing data are lines are going back and forth.

Anyone seen similar behaviour?

Screenshot 2020-11-27 at 12.43.47
Screenshot 2020-11-27 at 12.43.471762×464 57.5 KB

Amazon AWS Timestream

2

Seems my query was not correct.

SELECT
  	CREATE_TIME_SERIES(time, measure_value::double) AS temp_living
FROM $__database.$__table
WHERE $__timeFilter
  AND measure_name = 'temp'

My first attempt was more like:

SELECT measure_value::double AS "temperature living", time FROM "IOT"."sensor_data"  AND $__timeFilter(time)
where "measure_name" = 'temp'