turbot/digitalocean_insights

Query: network_load_balancers_for_droplet

Usage

powerpipe query digitalocean_insights.query.network_load_balancers_for_droplet

SQL

select
l.urn as lb_urn
from
digitalocean_droplet as d,
digitalocean_load_balancer as l,
jsonb_array_elements(droplet_ids) as did
where
d.id::text = did::text
and d.urn = $1;