| Actor | Fragment | Worker | State |
|---|---|---|---|
| 741590 | 44345 | 51 | running |
| 741591 | 44345 | 51 | running |
| 741596 | 44346 | 51 | running |
| 741597 | 44346 | 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