Control: SQL database instances should be labeled

Description

Check if SQL database instances have at least 1 label.

Usage

Run the control in your terminal:

powerpipe control run gcp_labels.control.sql_database_instance_unlabeled

Snapshot and share results via Turbot Pipes:

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

Steampipe Tables

gcp_sql_database_instance

SQL

select
  self_link as resource,
  case
    when labels is not null then 'ok'
    else 'alarm'
  end as status,
  case
    when labels is not null then title || ' has labels.'
    else title || ' has no labels.'
  end as reason,
  location, project
from
  gcp_sql_database_instance