| Actor | Fragment | Worker | State |
|---|---|---|---|
| 736067 | 51595 | 51 | running |
| 736068 | 51595 | 51 | running |
| 736069 | 51596 | 51 | running |
| 736070 | 51596 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.account_reference_identifiers_mv AS
SELECT
ri.entity_id AS account_id,
JSONB_AGG(JSONB_BUILD_OBJECT('key', ri.key, 'value', ri.value) ORDER BY ri.key) AS reference_identifiers
FROM olap.reference_identifiers AS ri
WHERE
ri.entity_type = 'account'
GROUP BY
ri.entity_id