turbot/gcp_insights

Query: sql_database_instance_ssl_enabled

Usage

powerpipe query gcp_insights.query.sql_database_instance_ssl_enabled

SQL

select
'SSL' as label,
case
when ip_configuration -> 'requireSsl' is null then 'Disabled'
else 'Enabled'
end as value,
case
when ip_configuration -> 'requireSsl' is null
then 'alert'
else 'ok'
end as type
from
gcp_sql_database_instance
where
project = split_part($1, '/', 7)
and self_link = $1;

Dashboards

The query is used in the dashboards: