Control: Compute forwarding rules should not exceed label limit

Description

Check if the number of labels on Compute forwarding rules do not exceed the limit.

Usage

Run the control in your terminal:

powerpipe control run gcp_labels.control.compute_forwarding_rule_label_limit

Snapshot and share results via Turbot Pipes:

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

Steampipe Tables

gcp_compute_forwarding_rule

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_compute_forwarding_rule
)
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