turbot/gcp_insights

Query: source_compute_firewalls_for_iam_service_account

Usage

powerpipe query gcp_insights.query.source_compute_firewalls_for_iam_service_account

Steampipe Tables

SQL

select
id::text as source_firewall_id
from
gcp_compute_firewall,
jsonb_array_elements_text(target_service_accounts) as t
where
t = split_part($1, '/', 1);