Query: org_domain_verified

select
  -- Required Columns
  url as resource,
  case
    when is_verified then 'ok'
    else 'alarm'
  end as status,
  coalesce(name, login) || ' domain is ' || case when (is_verified)::bool then 'verified' else 'not verified' end || '.' as reason,
  -- Additional Dimensions
  login
from
  github_my_organization;