turbot/digitalocean_insights

Query: droplet_attached_volumes

Usage

powerpipe query digitalocean_insights.query.droplet_attached_volumes

SQL

select
v.name as "Name",
v.id as "ID",
v.created_at as "Create Time",
v.urn as "URN"
from
digitalocean_droplet as d,
jsonb_array_elements_text(d.volume_ids) as volume_id,
digitalocean_volume as v
where
v.id = volume_id
and d.urn = $1
order by
v.name;

Dashboards

The query is used in the dashboards: