| Actor | Fragment | Worker | State |
|---|---|---|---|
| 156629 | 12378 | 33 | running |
| 156630 | 12378 | 33 | running |
| 156631 | 12379 | 33 | running |
| 156632 | 12379 | 33 | running |
| 156633 | 12380 | 33 | running |
| 156634 | 12380 | 33 | running |
| 156635 | 12381 | 33 | running |
| 156636 | 12381 | 33 | running |
| 156637 | 12382 | 33 | running |
| 156638 | 12382 | 33 | running |
CREATE MATERIALIZED VIEW alpheya_experience_bff.party_active_customer_relationships_mv WITH ( backfill_order=FIXED(party.parties -> party.customer_relationships) ) AS SELECT cr.party_id, cr.id AS customer_relationship_id FROM party.customer_relationships AS cr JOIN party.parties AS p ON p.id = cr.party_id AND p.disabled_at IS NULL WHERE cr.type = 'CUSTOMER' AND cr.status = 'ACTIVE' AND cr.disabled_at IS NULL GROUP BY cr.party_id, cr.id