RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

CREATE MATERIALIZED VIEW authz.team_to_accounts_mv AS
SELECT
  account_access.team_id,
  account_access.account_id,
  MAX(account_access.updated_at) AS updated_at
FROM (
  SELECT
    etm.team_id,
    atc.account_id,
    GREATEST(etm.updated_at, atc.updated_at) AS updated_at
  FROM olap.entity_to_teams_dm AS etm
  JOIN olap.accounts_to_clients_dm AS atc
    ON etm.entity_id = atc.client_id
  WHERE
    etm.entity_type = 'CLIENT'
    AND etm.disabled_at IS NULL
    AND etm.effective_end_date IS NULL
    AND atc.disabled_at IS NULL
    AND atc.effective_end_date IS NULL
  UNION ALL
  SELECT
    tp.team_id,
    apa.account_id,
    GREATEST(tp.updated_at, apa.updated_at) AS updated_at
  FROM authz.team_to_parties_mv AS tp
  JOIN authz.active_parties_to_accounts_mv AS apa
    ON apa.party_id = tp.party_id
  UNION ALL
  SELECT
    tp.team_id,
    atp.account_id,
    tp.updated_at AS updated_at
  FROM authz.team_to_portfolios_mv AS tp
  JOIN olap.account_to_portfolios_dm AS atp
    ON atp.portfolio_id = tp.portfolio_id
  WHERE
    atp.disabled_at IS NULL AND atp.effective_end_date IS NULL
) AS account_access
GROUP BY
  account_access.team_id,
  account_access.account_id