RWM Console cluster: risingwave-adib.adib-rw.svc.cluster.local

CREATE MATERIALIZED VIEW authz.team_to_portfolios_mv AS
SELECT
  portfolio_access.team_id,
  portfolio_access.portfolio_id,
  MAX(portfolio_access.updated_at) AS updated_at
FROM (
  SELECT
    etm.team_id,
    cp.portfolio_id,
    etm.updated_at
  FROM olap.entity_to_teams_dm AS etm
  JOIN olap.clients_portfolios_dm AS cp
    ON etm.entity_id = cp.client_id
  WHERE
    etm.entity_type = 'CLIENT'
    AND etm.disabled_at IS NULL
    AND etm.effective_end_date IS NULL
    AND cp.disabled_at IS NULL
    AND cp.effective_end_date IS NULL
  UNION ALL
  SELECT
    tp.team_id,
    app.portfolio_id,
    tp.updated_at
  FROM authz.team_to_parties_mv AS tp
  JOIN authz.active_parties_to_portfolios_mv AS app
    ON app.party_id = tp.party_id
  UNION ALL
  SELECT
    etm.team_id,
    etm.entity_id AS portfolio_id,
    etm.updated_at
  FROM olap.entity_to_teams_dm AS etm
  WHERE
    etm.entity_type = 'PORTFOLIO'
    AND etm.disabled_at IS NULL
    AND etm.effective_end_date IS NULL
) AS portfolio_access
GROUP BY
  portfolio_access.team_id,
  portfolio_access.portfolio_id