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: