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
self_link = $1;

Dashboards

The query is used in the dashboards: