Query: pod_service_account_not_exist

select
  coalesce(p.uid, concat(p.path, ':', p.start_line)) as resource,
  case
    when service_account_name is not null
    and service_account_name <> '' then 'ok'
    else 'alarm'
  end as status,
  case
    when service_account_name is not null
    and service_account_name <> '' then p.name || ' refer to an existing service account.'
    else p.name || ' does not refer to an existing service account.'
  end as reason,
  p.name as pod_name,
  coalesce(p.context_name, '') as context_name,
  p.namespace,
  p.source_type,
  coalesce(p.path || ':' || p.start_line || '-' || p.end_line, '') as path
from
  kubernetes_pod p
  left join kubernetes_service_account a on p.service_account_name = a.name;