turbot/gcp_insights

Query: storage_bucket_tags_detail

Usage

powerpipe query gcp_insights.query.storage_bucket_tags_detail

Steampipe Tables

SQL

with jsondata as (
select
tags::json as tags
from
gcp_storage_bucket
where
id = split_part($1, '/', 1)
and project = split_part($1, '/', 2)
)
select
key as "Key",
value as "Value"
from
jsondata,
json_each_text(tags)
order by
key;

Dashboards

The query is used in the dashboards: