Table

companies

Each row represents a tenant site with subdomain, branding names, organization link, and status.

statusgroupRedshift

Each row represents a tenant site with subdomain, branding names, organization link, and status.

Full schema

Yes, this table includes a statusgroup column. See Status Group for details.

select
  t.name,
  t.customhost,
  t.subdomain,
  t.organizationid,
  t.copyrightname
from companies as t
limit 100