Query: ecs_snapshot_age

with data as (
  select
    (
      extract(
        epoch
        from
          (
            select
              (now() - creation_time)
          )
      ) / 86400
    ) :: int as age
  from
    alicloud_ecs_snapshot
  where
    arn = $1
)
select
  'Age (in Days)' as label,
  age as value,
  case
    when age < 35 then 'ok'
    else 'alert'
  end as type
from
  data;