Query: blockstorage_volume_attached_droplets_count

select
  'Attached Droplets' as label,
  case
    when droplet_ids is null then 0
    else jsonb_array_length(droplet_ids)
  end as value,
  case
    when jsonb_array_length(droplet_ids) > 0 then 'ok'
    else 'alert'
  end as "type"
from
  digitalocean_volume
where
  urn = $1;