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;