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

← cluster insights objects user_to_portfolios_mv
Overview Objects Graph History
materialized view · insights.user_to_portfolios_mv
Parallelism
2
Actors
8 / 8
running
Distribution
HASH
Rows
0
State size
—
Created
2026-06-30 21:32
Initialized
2026-06-30 21:32
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
53770 2346 3 running
53771 2346 3 running
53772 2347 3 running
53773 2347 3 running
53829 2349 3 running
53830 2349 3 running
53836 2348 3 running
53837 2348 3 running
sql · insights.user_to_portfolios_mv — click to expand 
CREATE MATERIALIZED VIEW insights.user_to_portfolios_mv AS
SELECT DISTINCT
  tm.user_id,
  ett.entity_id AS portfolio_id
FROM olap.teams_memberships_dm AS tm
JOIN olap.entity_to_teams_dm AS ett
  ON ett.team_id = tm.team_id AND ett.entity_type = 'PORTFOLIO'
WHERE
  tm.disabled_at IS NULL AND NOT tm.temporary IS TRUE AND ett.disabled_at IS NULL
Lineage · insights.user_to_portfolios_mv 4 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.