| Actor | Fragment | Worker | State |
|---|---|---|---|
| 736658 | 51769 | 51 | running |
| 736659 | 51769 | 51 | running |
| 736660 | 51768 | 51 | running |
| 736661 | 51768 | 51 | running |
| 736662 | 51770 | 51 | running |
| 736663 | 51770 | 51 | running |
| 736664 | 51771 | 51 | running |
| 736665 | 51771 | 51 | running |
| 736666 | 51772 | 51 | running |
| 736667 | 51772 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.expiring_identifiers_mv WITH ( backfill_order=FIXED(party.parties -> party.party_identifiers) ) AS SELECT pi.id AS identifier_id, pi.party_id, pi.type AS identifier_type, pi.expiry_date FROM party.party_identifiers AS pi JOIN party.parties AS p ON p.id = pi.party_id WHERE pi.disabled_at IS NULL AND p.disabled_at IS NULL AND NOT pi.expiry_date IS NULL