Control: Compute Subnetworks should have Private IPv6 Google Access enabled
Description
This control checks if Compute Subnetworks have Private IPv6 Google Access enabled.
Usage
Run the control in your terminal:
powerpipe control run terraform_gcp_compliance.control.compute_subnetwork_private_ipv6_google_access
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_gcp_compliance.control.compute_subnetwork_private_ipv6_google_access --share
SQL
This control uses a named query:
select address as resource, case when (attributes_std ->> 'private_ipv6_google_access') in ('ENABLE_OUTBOUND_VM_ACCESS_TO_GOOGLE', 'ENABLE_BIDIRECTIONAL_ACCESS_TO_GOOGLE') then 'ok' else 'alarm' end as status, split_part(address, '.', 2) || case when (attributes_std ->> 'private_ipv6_google_access') in ('ENABLE_OUTBOUND_VM_ACCESS_TO_GOOGLE', 'ENABLE_BIDIRECTIONAL_ACCESS_TO_GOOGLE') then ' private IPv6 Google Access is enabled' else ' private IPv6 Google Access is disabled' end || '.' reason , path || ':' || start_linefrom terraform_resourcewhere type = 'google_compute_subnetwork';