turbot/digitalocean_insights

Query: droplet_droplets_for_blockstorage_volume

Usage

powerpipe query digitalocean_insights.query.droplet_droplets_for_blockstorage_volume

SQL

select
d.urn as droplet_urn
from
digitalocean_volume as v,
jsonb_array_elements(v.droplet_ids) as droplet_id,
digitalocean_droplet as d
where
d.id = droplet_id::bigint
and v.urn = $1;