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

CREATE MATERIALIZED VIEW authz.team_to_parties_mv AS
SELECT
  etm.team_id,
  etm.entity_id AS party_id,
  MAX(etm.updated_at) AS updated_at
FROM olap.entity_to_teams_dm AS etm
WHERE
  etm.entity_type = 'PARTY'
  AND etm.disabled_at IS NULL
  AND etm.effective_start_date <= CURRENT_TIMESTAMP
  AND (
    etm.effective_end_date IS NULL OR etm.effective_end_date > CURRENT_TIMESTAMP
  )
  AND EXISTS(
    SELECT
      1
    FROM party.customer_relationships AS cr
    WHERE
      cr.party_id = etm.entity_id
      AND cr.type = 'CUSTOMER'
      AND cr.status IN ('ACTIVE', 'DRAFT', 'PENDING')
      AND cr.disabled_at IS NULL
  )
  AND EXISTS(
    SELECT
      1
    FROM party.parties AS p
    WHERE
      p.id = etm.entity_id AND p.disabled_at IS NULL
  )
GROUP BY
  etm.team_id,
  etm.entity_id