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

← cluster ai_hub_bff objects book_of_business_clients_mv
Overview Objects Graph History
materialized view · ai_hub_bff.book_of_business_clients_mv Explain plan ▶
Parallelism
2
Actors
10 / 10
running
Distribution
HASH
Rows
54
State size
13.0 KiB
Created
2026-08-14 12:38
Initialized
2026-08-14 12:38
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
159740 15022 33 running
159741 15022 33 running
159742 15023 33 running
159743 15023 33 running
159744 15025 33 running
159745 15025 33 running
159748 15024 33 running
159749 15024 33 running
159750 15026 33 running
159751 15026 33 running
sql · ai_hub_bff.book_of_business_clients_mv — click to expand 
CREATE MATERIALIZED VIEW ai_hub_bff.book_of_business_clients_mv AS
SELECT
  c.id AS client_id,
  c.type AS client_type,
  c.base_currency_code,
  c.created_at,
  c.onboarding_date,
  cag.type AS account_group_type,
  c.display_name,
  c.local_display_name,
  c.preferred_name,
  c.prefix,
  c.suffix,
  c.first_name,
  c.last_name,
  c.customer_identification_file,
  c.segment_label_id,
  c.status_label_id
FROM olap.clients_dm AS c
JOIN insights.client_to_account_groups_mv AS cag
  ON c.id = cag.client_id
WHERE
  c.closing_date IS NULL AND c.disabled_at IS NULL
Lineage · ai_hub_bff.book_of_business_clients_mv 5 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.