client_contact_counts_mv · alpheya_experience_bff

← cluster alpheya_experience_bff objects client_contact_counts_mv

Overview Objects Graph History

materialized view · alpheya_experience_bff.client_contact_counts_mv Explain plan ▶

Parallelism

Actors

4 / 4

running

Distribution

HASH

Rows

State size

—

Created

2026-08-11 21:25

Initialized

2026-08-11 21:24

Fragment flags

LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
156753	12437	33	running
156754	12437	33	running
156783	12438	33	running
156784	12438	33	running

sql · alpheya_experience_bff.client_contact_counts_mv — click to expand

CREATE MATERIALIZED VIEW alpheya_experience_bff.client_contact_counts_mv AS
SELECT
  client_id,
  CAST(COUNT(contact_person_id) AS INT) AS contact_count
FROM olap.clients_to_contact_persons_dm
WHERE
  disabled_at IS NULL
GROUP BY
  client_id

Lineage · alpheya_experience_bff.client_contact_counts_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.

RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local