turbot/digitalocean_insights

Query: droplet_droplets_for_database_cluster

Usage

powerpipe query digitalocean_insights.query.droplet_droplets_for_database_cluster

SQL

select
d.urn as droplet_urn
from
digitalocean_database as db,
jsonb_array_elements(firewall_rules) as fr,
digitalocean_droplet as d
where
fr ->> 'type' = 'droplet'
and d.id::text = fr ->> 'value'
and db.urn = $1;