turbot/digitalocean_insights

Query: database_cluster_firewall_enabled

Usage

powerpipe query digitalocean_insights.query.database_cluster_firewall_enabled

Steampipe Tables

SQL

select
'Firewall' as label,
case
when jsonb_array_length(firewall_rules) = 0 then 'Disabled'
else 'Enabled'
end as value,
case
when jsonb_array_length(firewall_rules) = 0 then 'alert'
else 'ok'
end as type
from
digitalocean_database
where
urn = $1;

Dashboards

The query is used in the dashboards: