turbot/digitalocean_insights

Query: network_floating_ips_for_snapshot

Usage

powerpipe query digitalocean_insights.query.network_floating_ips_for_snapshot

SQL

select
f.urn as floating_ip_urn
from
digitalocean_floating_ip as f,
jsonb_array_elements(droplet -> 'snapshot_ids') as sid,
digitalocean_snapshot as s
where
s.id = sid :: text
and s.id = $1;