Control: Cloud SQL instances should not be publicly accessible

powerpipe control run gcp_perimeter.control.cloud_sql_not_publicly_accessible

powerpipe login
powerpipe control run gcp_perimeter.control.cloud_sql_not_publicly_accessible --share

select
  self_link as resource,
  case
    when ip_configuration ->> 'ipv4Enabled' = 'true' then 'alarm'
    else 'ok'
  end as status,
  case
    when ip_configuration ->> 'ipv4Enabled' = 'true' then title || ' has public access enabled.'
    else title || ' does not have public access enabled.'
  end as reason
  
  , location, project
from
  gcp_sql_database_instance;