| Actor | Fragment | Worker | State |
|---|---|---|---|
| 736624 | 51773 | 51 | running |
| 736625 | 51773 | 51 | running |
| 736626 | 51774 | 51 | running |
| 736627 | 51774 | 51 | running |
| 736670 | 51776 | 51 | running |
| 736671 | 51776 | 51 | running |
| 736672 | 51775 | 51 | running |
| 736673 | 51775 | 51 | running |
| 736674 | 51777 | 51 | running |
| 736675 | 51777 | 51 | running |
| 736676 | 51778 | 51 | running |
| 736677 | 51778 | 51 | running |
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