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

← cluster authz objects user_accessible_clients_mv
Overview Objects Graph History
materialized view · authz.user_accessible_clients_mv
Parallelism
2
Actors
8 / 8
running
Distribution
HASH
Rows
25
State size
2.4 KiB
Created
2026-06-30 21:32
Initialized
2026-06-30 21:32
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
53747 2350 3 running
53748 2350 3 running
53749 2351 3 running
53750 2351 3 running
53846 2352 3 running
53847 2352 3 running
53848 2353 3 running
53849 2353 3 running
sql · authz.user_accessible_clients_mv — click to expand 
CREATE MATERIALIZED VIEW authz.user_accessible_clients_mv AS
SELECT
  tm.user_id,
  etm.entity_id AS client_id,
  MAX(GREATEST(tm.updated_at, etm.updated_at)) AS updated_at
FROM olap.teams_memberships_dm AS tm
JOIN olap.entity_to_teams_dm AS etm
  ON tm.team_id = etm.team_id AND etm.entity_type = 'CLIENT'
WHERE
  tm.disabled_at IS NULL
  AND NOT tm.temporary IS TRUE
  AND etm.disabled_at IS NULL
  AND etm.effective_end_date IS NULL
GROUP BY
  tm.user_id,
  etm.entity_id
Lineage · authz.user_accessible_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.