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

← cluster insights objects investment_account_purchasing_power_mv
Overview Objects Graph History
materialized view · insights.investment_account_purchasing_power_mv
Parallelism
2
Actors
10 / 10
running
Distribution
HASH
Rows
0
State size
—
Created
2026-06-30 21:43
Initialized
2026-06-30 21:43
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
54274 2608 3 running
54275 2608 3 running
54276 2609 3 running
54277 2609 3 running
54278 2611 3 running
54279 2611 3 running
54280 2612 3 running
54281 2612 3 running
54286 2610 3 running
54287 2610 3 running
sql · insights.investment_account_purchasing_power_mv — click to expand 
CREATE MATERIALIZED VIEW insights.investment_account_purchasing_power_mv AS
SELECT
  iaf.account_id,
  iaf.fact_date,
  iaf.purchasing_power,
  iaf.purchasing_power * COALESCE(fx.rate, CASE WHEN a.base_currency_code = 'SAR' THEN 1 ELSE NULL END) AS purchasing_power_system_currency,
  iaf.disabled_at
FROM olap.investment_accounts_ft AS iaf
LEFT JOIN olap.accounts_dm AS a
  ON a.account_id = iaf.account_id
LEFT JOIN insights.fx_rates_snapshot_mv AS fx
  ON fx.source_currency_code = a.base_currency_code
  AND fx.target_currency_code = 'SAR'
WHERE
  iaf.disabled_at IS NULL
Lineage · insights.investment_account_purchasing_power_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.