turbot/gcp_compliance

Query: sql_instance_require_ssl_enabled

Usage

powerpipe query gcp_compliance.query.sql_instance_require_ssl_enabled

SQL

select
self_link resource,
case
when ip_configuration -> 'requireSsl' is null then 'alarm'
else 'ok'
end as status,
case
when ip_configuration -> 'requireSsl' is null
then title || ' does not enforce SSL connections.'
else title || ' enforces SSL connections.'
end as reason
, location as location, project as project
from
gcp_sql_database_instance;

Controls

The query is being used by the following controls: