| Actor | Fragment | Worker | State |
|---|---|---|---|
| 741606 | 44347 | 51 | running |
| 741607 | 44347 | 51 | running |
| 741610 | 44348 | 51 | running |
| 741611 | 44348 | 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