Dashboard: GCP Storage Bucket Dashboard

This dashboard answers the following questions:

How many buckets are in each project and location?
How many public buckets are there?
How many buckets do not have versioning, logging and uniform bucket level access enabled?

This dashboard contains 6 cards.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-gcp-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select GCP Storage Bucket Dashboard dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run gcp_insights.dashboard.storage_bucket_dashboard --share

Queries

This dashboard uses the the following queries:

with buckets as (
  select
    title,
    time_created,
    to_char(time_created,
      'YYYY-MM') as creation_month
  from
    gcp_storage_bucket
),
months as (
  select
    to_char(d,
      'YYYY-MM') as month
  from
    generate_series(date_trunc('month',
    (
    select 
      min(time_created)
    from buckets)),
    date_trunc('month',
      current_date),
    interval '1 month') as d
),
buckets_by_month as (
  select
    creation_month,
    count(*)
  from
    buckets
  group by
    creation_month
)
select
  months.month,
  buckets_by_month.count
from
  months
  left join buckets_by_month on months.month = buckets_by_month.creation_month
order by
  months.month;

Dashboard: GCP Storage Bucket Dashboard

Usage

Queries

Tags