turbot/gcp_insights

Query: target_compute_firewalls_for_iam_service_account

Usage

powerpipe query gcp_insights.query.target_compute_firewalls_for_iam_service_account

Steampipe Tables

SQL

select
id::text as target_firewall_id
from
gcp_compute_firewall,
jsonb_array_elements_text(source_service_accounts) as s
where
s = split_part($1, '/', 1);