turbot/gcp_insights

Query: source_compute_snapshots_for_compute_disk

Usage

powerpipe query gcp_insights.query.source_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.source_snapshot = s.self_link;