Control: Block storage volume snapshots created over 90 days ago should be deleted if not required

powerpipe control run digitalocean_thrifty.control.block_storage_volume_snapshot_age_90

powerpipe login
powerpipe control run digitalocean_thrifty.control.block_storage_volume_snapshot_age_90 --share

select
  a.id as resource,
  case
    when a.created_at > (current_timestamp - ($1::int || ' days')::interval) then 'ok'
    else 'alarm'
  end as status,
  a.title || ' has been created for ' || date_part('day', now() - a.created_at) || ' day(s).' as reason
  , r.name as region
  
from
  digitalocean_snapshot a,
  jsonb_array_elements_text(regions) as region
  left join digitalocean_region as r on r.slug = region
where
  a.resource_type = 'volume';