turbot/digitalocean_insights

Query: target_droplet_droplets_for_snapshot

Usage

powerpipe query digitalocean_insights.query.target_droplet_droplets_for_snapshot

SQL

select
d.urn as target_droplet_urn
from
digitalocean_image as i,
digitalocean_snapshot as s,
digitalocean_droplet as d
where
i.id::text = image->>'id'
and i.id::text = s.id
and s.id = $1;