Control: BigQuery jobs should be labeled

Description

Check if BigQuery jobs have at least 1 label.

Usage

Run the control in your terminal:

powerpipe control run gcp_labels.control.bigquery_job_unlabeled

Snapshot and share results via Turbot Pipes:

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

Steampipe Tables

gcp_bigquery_job

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_bigquery_job