turbot/digitalocean_insights

Query: droplet_by_public_access

Usage

powerpipe query digitalocean_insights.query.droplet_by_public_access

Steampipe Tables

SQL

with droplets as (
select
case
when image ->> 'public' = 'true' then 'public'
else 'private'
end as public_access
from
digitalocean_droplet
)
select
public_access,
count(*) as "Droplets"
from
droplets
group by
public_access;

Dashboards

The query is used in the dashboards: