Control: Large block storage volumes are unusual, expensive and should be reviewed.

powerpipe control run digitalocean_thrifty.control.block_storage_volume_large

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

select
  v.urn as resource,
  case
    when v.size_gigabytes <= $1 then 'ok'
    else 'alarm'
  end as status,
  v.id || ' is ' || v.size_gigabytes || 'GB.' as reason
  , r.name as region
  
from
  digitalocean_volume as v
  left join digitalocean_region as r on r.slug = v.region_slug;