Control: SQL database instances should not exceed label limit

Description

Check if the number of labels on SQL database instances do not exceed the limit.

Usage

Run the control in your terminal:

powerpipe control run gcp_labels.control.sql_database_instance_label_limit

Snapshot and share results via Turbot Pipes:

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

Steampipe Tables

gcp_sql_database_instance

SQL

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