Control: Database clusters created over 90 days ago should be reviewed

powerpipe control run digitalocean_thrifty.control.database_long_running

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

select
  d.urn as resource,
  case
    when date_part('day', now() - d.created_at) > $1 then 'alarm'
    else 'ok'
  end as status,
  d.title || ' of ' || d.engine || ' type in use for ' || date_part('day', now() - d.created_at) || ' day(s).' as reason
  , r.name as region
  
from
  digitalocean_database as d
  left join digitalocean_region as r on r.slug = d.region_slug;