Query: namespace_resource_quota_memory_request

select
  distinct(coalesce(n.uid, concat(n.path, ':', n.start_line))) as resource,
  case
    when q.spec_hard -> 'requests.memory' is null
    and q.spec_hard -> 'memory' is null then 'alarm'
    else 'ok'
  end as status,
  case
    when q.spec_hard -> 'requests.memory' is null
    and q.spec_hard -> 'memory' is null then n.name || ' do not have ResourceQuota for memory request.'
    else n.name || ' have ResourceQuota for memory request.'
  end as reason,
  coalesce(n.context_name, '') as context_name,
  n.name,
  n.source_type,
  coalesce(n.path || ':' || n.start_line || '-' || n.end_line, '') as path
from
  kubernetes_namespace n
  left join kubernetes_resource_quota q on n.name = q.namespace;