turbot/digitalocean_insights

Query: snapshot_source_blockstorage_volume

Usage

powerpipe query digitalocean_insights.query.snapshot_source_blockstorage_volume

SQL

select
v.urn as "URN",
v.name as "Name",
v.id as "ID",
v.size_gigabytes as "Size (GB)"
from
digitalocean_volume as v,
digitalocean_snapshot as s
where
s.resource_id = v.id
and s.resource_type = 'volume'
and s.id = $1;

Dashboards

The query is used in the dashboards: