| Actor | Fragment | Worker | State |
|---|---|---|---|
| 156656 | 12387 | 33 | running |
| 156657 | 12387 | 33 | running |
| 156658 | 12388 | 33 | running |
| 156659 | 12388 | 33 | running |
| 156660 | 12389 | 33 | running |
| 156661 | 12389 | 33 | running |
| 156662 | 12390 | 33 | running |
| 156663 | 12390 | 33 | running |
| 156664 | 12391 | 33 | running |
| 156665 | 12391 | 33 | running |
| 156666 | 12392 | 33 | running |
| 156667 | 12392 | 33 | 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