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

← cluster insights objects asset_prices_snapshot_mv
Overview Objects Graph History
materialized view · insights.asset_prices_snapshot_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
3,215
State size
230.5 KiB
Created
2026-08-26 08:18
Initialized
2026-08-26 08:18
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
121007 25126 26 running
121008 25126 26 running
121009 25127 26 running
121010 25127 26 running
sql · insights.asset_prices_snapshot_mv — click to expand 
CREATE MATERIALIZED VIEW insights.asset_prices_snapshot_mv AS
SELECT
  asset_id,
  close,
  CAST(date AS TIMESTAMPTZ) AS value_timestamp
FROM (
  SELECT
    asset_id,
    close,
    date,
    ROW_NUMBER() OVER (PARTITION BY asset_id ORDER BY date DESC) AS rn
  FROM asset_service.asset_prices_eod_ft AS asset_prices_eod_ft_next
  WHERE
    NOT close IS NULL
)
WHERE
  rn = 1
Lineage · insights.asset_prices_snapshot_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.