AWS Grafana alert showing No_data using timestream db

I am using Amazon managed grafana with timestream table to visualize temperature readings on my panel. I am getting the plots on the graph fine, but when i set alerts, it is alerting “no_data”. when testing the alert rule, it displays a messaeg which implies the value of the metric is null. I will attach an image of the test rule. I have attached the timestream query I’ve used along with the table the query is returning and the alert conditions.


fixed the issue. There was an update on the AWS grafana workspace. Had to turn on Grafana alerting and change the query i used there to :

select measure_value::double as Sensor1,time 
from $__database.$__table 
where measure_name='Sensor1' 
order by time desc limit 1