turbot/gcp_insights

Query: target_compute_snapshots_for_compute_disk

Usage

powerpipe query gcp_insights.query.target_compute_snapshots_for_compute_disk

SQL

select
s.name as snapshot_name
from
gcp_compute_disk d,
gcp_compute_snapshot s
where
d.id = (split_part($1, '/', 1))::bigint
and d.project = split_part($1, '/', 2)
and d.self_link = s.source_disk;