Control: BigQuery jobs should not exceed label limit

Description

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

Usage

Run the control in your terminal:

powerpipe control run gcp_labels.control.bigquery_job_label_limit

Snapshot and share results via Turbot Pipes:

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

Steampipe Tables

gcp_bigquery_job

SQL

with analysis as (
  select
    self_link,
    title,
    cardinality(array(select jsonb_object_keys(labels))) as num_label_keys,
    location, project
  from
    gcp_bigquery_job
)
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

Params

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