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

← cluster alinma_bff objects advisor_kpi_user_clients_mv
Overview Objects Graph History
materialized view · alinma_bff.advisor_kpi_user_clients_mv Explain plan ▶
Parallelism
2
Actors
12 / 12
running
Distribution
HASH
Rows
261
State size
21.7 KiB
Created
2026-08-20 16:56
Initialized
2026-08-20 16:56
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
742452 62500 51 running
742453 62500 51 running
742876 62497 51 running
742877 62497 51 running
742878 62498 51 running
742879 62498 51 running
742880 62499 51 running
742881 62499 51 running
742890 62501 51 running
742891 62501 51 running
742892 62502 51 running
742893 62502 51 running
sql · alinma_bff.advisor_kpi_user_clients_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_user_clients_mv AS
SELECT
  user_clients.user_id,
  user_clients.client_id
FROM (
  SELECT
    utm.user_id,
    ttc.client_id
  FROM authz.active_teams_memberships_mv AS utm
  JOIN authz.team_to_clients_mv AS ttc
    ON ttc.team_id = utm.team_id
  WHERE
    utm.access_type = 'DIRECT'
) AS user_clients
GROUP BY
  user_clients.user_id,
  user_clients.client_id
Lineage · alinma_bff.advisor_kpi_user_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.