turbot/gcp_insights

Query: sql_database_instance_encryption

Usage

powerpipe query gcp_insights.query.sql_database_instance_encryption

SQL

select
'Encryption' as label,
case when kms_key_name is null then 'Disabled' else 'Enabled' end as value,
case when kms_key_name 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: