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

← cluster insights objects portfolio_to_account_groups_mv
Overview Objects Graph History
materialized view · insights.portfolio_to_account_groups_mv
Parallelism
2
Actors
10 / 10
running
Distribution
HASH
Rows
48
State size
5.7 KiB
Created
2026-06-30 21:34
Initialized
2026-06-30 21:34
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
53926 2379 3 running
53927 2379 3 running
53936 2382 3 running
53937 2382 3 running
53938 2381 3 running
53939 2381 3 running
53940 2380 3 running
53941 2380 3 running
53942 2383 3 running
53943 2383 3 running
sql · insights.portfolio_to_account_groups_mv — click to expand 
CREATE MATERIALIZED VIEW insights.portfolio_to_account_groups_mv AS
SELECT
  p.portfolio_id,
  'account_group_' || MD5(CAST((
    p.portfolio_id || 'all'
  ) AS BYTEA)) AS account_group_id,
  CAST('all' AS VARCHAR) AS type
FROM olap.portfolios_dm AS p
WHERE
  p.disabled_at IS NULL AND NOT p.m_is_stub IS TRUE
UNION ALL
SELECT
  p.portfolio_id,
  'account_group_' || MD5(CAST((
    p.portfolio_id || 'restricted'
  ) AS BYTEA)) AS account_group_id,
  CAST('restricted' AS VARCHAR) AS type
FROM olap.portfolios_dm AS p
WHERE
  p.disabled_at IS NULL AND NOT p.m_is_stub IS TRUE
UNION ALL
SELECT
  p.portfolio_id,
  'account_group_' || MD5(CAST((
    p.portfolio_id || 'un_restricted'
  ) AS BYTEA)) AS account_group_id,
  CAST('un_restricted' AS VARCHAR) AS type
FROM olap.portfolios_dm AS p
WHERE
  p.disabled_at IS NULL AND NOT p.m_is_stub IS TRUE
Lineage · insights.portfolio_to_account_groups_mv 6 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.