holding_values_latest_mv · insights

← cluster insights objects holding_values_latest_mv

Overview Objects Graph History

materialized view · insights.holding_values_latest_mv

Parallelism

Actors

4 / 4

running

Distribution

HASH

Rows

State size

—

Created

2026-06-30 21:50

Initialized

2026-06-30 21:49

Fragment flags

MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN

Actors

Actor	Fragment	Worker	State
54597	2802	3	running
54598	2802	3	running
54619	2803	3	running
54620	2803	3	running

sql · insights.holding_values_latest_mv — click to expand

CREATE MATERIALIZED VIEW insights.holding_values_latest_mv AS
SELECT
  account_id,
  asset_id,
  type,
  dim_value_date,
  currency_code,
  purchased_quantity,
  average_cost_per_unit,
  market_value,
  fair_value,
  accrued_value,
  market_value_system_currency,
  average_cost_system_currency,
  fair_value_system_currency,
  accrued_value_system_currency
FROM (
  SELECT
    account_id,
    asset_id,
    type,
    dim_value_date,
    currency_code,
    purchased_quantity,
    average_cost_per_unit,
    market_value,
    fair_value,
    accrued_value,
    market_value_system_currency,
    average_cost_system_currency,
    fair_value_system_currency,
    accrued_value_system_currency,
    ROW_NUMBER() OVER (PARTITION BY account_id, asset_id, type ORDER BY dim_value_date DESC) AS rn
  FROM insights.holding_values_mv
) AS ranked
WHERE
  rn = 1

Lineage · insights.holding_values_latest_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.

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