RWM Console cluster: risingwave.platform.svc.cluster.local

CREATE MATERIALIZED VIEW authz.active_party_memberships_mv AS
SELECT
  memberships.party_id,
  memberships.user_id
FROM (
  SELECT
    entity_id AS party_id,
    value AS user_id
  FROM party.reference_identifiers AS reference_identifiers_next
  WHERE
    entity_type = 'party' AND key = 'AlpheyaId' AND disabled_at IS NULL
  UNION ALL
  SELECT
    ttp.party_id,
    utm.user_id
  FROM authz.active_teams_memberships_mv AS utm
  JOIN authz.team_to_parties_mv AS ttp
    ON ttp.team_id = utm.team_id
) AS memberships
GROUP BY
  memberships.party_id,
  memberships.user_id