turbot/digitalocean_insights

Query: database_cluster_firewall_enabled_count

Usage

powerpipe query digitalocean_insights.query.database_cluster_firewall_enabled_count

Steampipe Tables

SQL

select
count(*) as value,
'Firewall Disabled' as label,
case
count(*)
when 0 then 'ok'
else 'alert'
end as "type"
from
digitalocean_database
where
jsonb_array_length(firewall_rules) = 0;

Dashboards

The query is used in the dashboards: