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

← cluster adib_rm objects sdk_asset_enrichment_mv
Overview Objects Graph History
materialized view · adib_rm.sdk_asset_enrichment_mv Explain plan ▶
Parallelism
2
Actors
8 / 8
running
Distribution
HASH
Rows
3,192
State size
664.4 KiB
Created
2026-08-24 15:32
Initialized
2026-08-24 15:32
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
104601 23625 26 running
104602 23625 26 running
104603 23624 26 running
104604 23624 26 running
104605 23623 26 running
104606 23623 26 running
104607 23626 26 running
104608 23626 26 running
sql · adib_rm.sdk_asset_enrichment_mv — click to expand 
CREATE MATERIALIZED VIEW adib_rm.sdk_asset_enrichment_mv AS
SELECT
  a.id AS asset_id,
  a.name_en AS asset_name_en,
  a.name_ar AS asset_name_ar,
  a.type AS asset_type,
  a.issue_currency_code,
  a.shariah_result AS sharia_compliance,
  a.ticker,
  a.isin,
  lp.price AS latest_price,
  lp.price_date AS latest_price_date,
  lp.price_change_pct_1d
FROM asset_service.assets_dm AS a
LEFT JOIN insights.asset_latest_price_mv AS lp
  ON lp.asset_id = a.id
Lineage · adib_rm.sdk_asset_enrichment_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.