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

← cluster alinma_bff objects marketplace_assets_mv
Overview Objects Graph History
materialized view · alinma_bff.marketplace_assets_mv Explain plan ▶
Parallelism
2
Actors
8 / 8
running
Distribution
HASH
Rows
385
State size
63.4 KiB
Created
2026-08-20 17:00
Initialized
2026-08-20 17:00
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
743021 62583 51 running
743022 62583 51 running
743023 62584 51 running
743024 62584 51 running
743047 62586 51 running
743048 62586 51 running
743709 62585 51 running
743710 62585 51 running
sql · alinma_bff.marketplace_assets_mv — click to expand
CREATE MATERIALIZED VIEW alinma_bff.marketplace_assets_mv AS
SELECT
  a.id AS asset_id,
  COALESCE(a.ticker, '') AS ticker,
  a.name_en,
  a.name_ar,
  a.type AS asset_type,
  a.issue_currency_code AS currency_code,
  a.isin,
  p.price,
  p.price_date,
  p.price_change_pct_1d AS price_change_percent
FROM asset_service.assets_dm AS a
LEFT JOIN insights.asset_latest_price_mv AS p
  ON p.asset_id = a.id
WHERE
  a.disabled_at IS NULL
Lineage · alinma_bff.marketplace_assets_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.