| Actor | Fragment | Worker | State |
|---|---|---|---|
| 736057 | 51598 | 51 | running |
| 736058 | 51598 | 51 | running |
| 736073 | 51597 | 51 | running |
| 736074 | 51597 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.client_reference_identifiers_mv AS
SELECT
ri.entity_id AS client_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 = 'client'
GROUP BY
ri.entity_id