I am trying to setup an alert based on the following query and i get an errror.
SELECT
sensor,
station,
file,
max(status_date) as status_date,
round(max(age_in_seconds/60)) as minutes
FROM
dea.hotspots_level0_stitched_status
WHERE
stitched_file = false
AND sensor = ‘MODIS’
AND age_in_seconds/60 > 15
GROUP BY
sensor,
station,
file
[sse.readDataError] [A] got error: input data must be a wide series but got type long (input refid)