turbot/digitalocean_insights

Query: network_firewalls_for_droplet

Usage

powerpipe query digitalocean_insights.query.network_firewalls_for_droplet

SQL

select
f.urn as firewall_urn
from
digitalocean_droplet as d,
digitalocean_firewall as f,
jsonb_array_elements(droplet_ids) as did
where
d.id::text = did::text
and d.urn = $1;