turbot/gcp_insights

Query: sql_database_instance_encryption_status

Usage

powerpipe query gcp_insights.query.sql_database_instance_encryption_status

SQL

select
encryption_status,
count(*)
from (
select name,
case when kms_key_name = '' then
'disabled'
else
'enabled'
end encryption_status
from
gcp_sql_database_instance) as c
group by
encryption_status
order by
encryption_status;

Dashboards

The query is used in the dashboards: