RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local

← cluster alinma_bff objects party_reference_identifiers_mv
Overview Objects Graph History
materialized view · alinma_bff.party_reference_identifiers_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
35
State size
3.3 KiB
Created
2026-08-20 17:01
Initialized
2026-08-20 17:01
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
743685 62630 51 running
743686 62630 51 running
743687 62631 51 running
743688 62631 51 running
sql · alinma_bff.party_reference_identifiers_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.party_reference_identifiers_mv AS
SELECT
  ri.entity_id AS party_id,
  MAX(ri.value) FILTER(WHERE
    ri.key = 'CustomerIdentificationFileId') AS customer_identification_file,
  JSONB_AGG(JSONB_BUILD_OBJECT('key', ri.key, 'value', ri.value) ORDER BY ri.key) AS reference_identifiers
FROM party.reference_identifiers AS ri
WHERE
  ri.entity_type = 'party' AND ri.disabled_at IS NULL
GROUP BY
  ri.entity_id
Lineage · alinma_bff.party_reference_identifiers_mv 3 objects
Direct (1-hop) dependencies from rw_depend, across schemas. Click a neighbor to expand its dependencies; ⌘/Ctrl-click opens its page. Drag to pan, scroll to zoom. External source/sink endpoints (Kafka, Iceberg) are not shown.