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

← cluster alinma_bff objects advisor_kpi_account_value_monthly_mv
Overview Objects Graph History
materialized view · alinma_bff.advisor_kpi_account_value_monthly_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
898
State size
94.7 KiB
Created
2026-08-20 17:23
Initialized
2026-08-20 17:23
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
746227 63496 51 running
746228 63496 51 running
746229 63497 51 running
746230 63497 51 running
sql · alinma_bff.advisor_kpi_account_value_monthly_mv — click to expand 
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_account_value_monthly_mv AS
SELECT
  account_id,
  period_start,
  aum,
  deposits,
  financing
FROM (
  SELECT
    account_id,
    CAST(DATE_TRUNC('MONTH', dim_value_date) AS DATE) AS period_start,
    aum,
    deposits,
    financing,
    ROW_NUMBER() OVER (
      PARTITION BY account_id, CAST(DATE_TRUNC('MONTH', dim_value_date) AS DATE)
      ORDER BY dim_value_date DESC
    ) AS rn
  FROM alinma_bff.advisor_kpi_account_value_daily_mv AS advisor_kpi_account_value_daily_mv_next
) AS t
WHERE
  t.rn = 1
Lineage · alinma_bff.advisor_kpi_account_value_monthly_mv 3 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.