Control: BigQuery tables should not exceed label limit

Description

Check if the number of labels on BigQuery tables do not exceed the limit.

Usage

Run the control in your terminal:

powerpipe control run gcp_labels.control.bigquery_table_label_limit

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run gcp_labels.control.bigquery_table_label_limit --share

Steampipe Tables

gcp_bigquery_table

Params

Args	Name	Default	Description	Variable
$1	label_limit	`60`		label_limit

SQL

with analysis as (
  select
    self_link,
    title,
    cardinality(array(select jsonb_object_keys(labels))) as num_label_keys,
    location, project
  from
    gcp_bigquery_table
)
select
  self_link as resource,
  case
    when num_label_keys > $1::integer then 'alarm'
    else 'ok'
  end as status,
  title || ' has ' || num_label_keys || ' label(s).' as reason,
  location, project
from
  analysis