turbot/digitalocean_insights

Query: snapshot_source_droplet

Usage

powerpipe query digitalocean_insights.query.snapshot_source_droplet

SQL

select
d.urn as "URN",
d.name as "Name",
d.id as "ID",
d.status as "Status"
from
digitalocean_droplet as d,
jsonb_array_elements(snapshot_ids) as sid,
digitalocean_snapshot as s
where
s.id = sid::text
and s.id = $1;

Dashboards

The query is used in the dashboards: