RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

← cluster insights objects fx_rates_snapshot_mv
Overview Objects Graph History
materialized view · insights.fx_rates_snapshot_mv Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
442
State size
18.6 KiB
Created
2026-08-19 08:30
Initialized
2026-08-19 08:30
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
157037 16683 33 running
157038 16683 33 running
157071 16684 33 running
157072 16684 33 running
sql · insights.fx_rates_snapshot_mv — click to expand 
CREATE MATERIALIZED VIEW insights.fx_rates_snapshot_mv AS
SELECT
  source_currency_code,
  target_currency_code,
  rate,
  CAST(date AS TIMESTAMPTZ) AS value_timestamp
FROM (
  SELECT
    source_currency_code,
    target_currency_code,
    rate,
    date,
    ROW_NUMBER() OVER (PARTITION BY source_currency_code, target_currency_code ORDER BY date DESC) AS rn
  FROM asset_service.foreign_exchange_rates_eod_ft
  WHERE
    source_currency_code <> target_currency_code
)
WHERE
  rn = 1
Lineage · insights.fx_rates_snapshot_mv 8 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.