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

← cluster insights objects asset_distributions_for_consumers_mv
Overview Objects Graph History
materialized view · insights.asset_distributions_for_consumers_mv
Parallelism
2
Actors
6 / 6
running
Distribution
HASH
Rows
4,389
State size
726.3 KiB
Created
2026-06-30 21:38
Initialized
2026-06-30 21:37
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
54130 2470 3 running
54131 2470 3 running
54132 2471 3 running
54133 2471 3 running
54134 2472 3 running
54135 2472 3 running
sql · insights.asset_distributions_for_consumers_mv — click to expand 
CREATE MATERIALIZED VIEW insights.asset_distributions_for_consumers_mv AS
SELECT
  ad.asset_id,
  CASE ad.dimension
    WHEN 'ASSET_CLASS'
    THEN 'asset_classes'
    WHEN 'SECTOR'
    THEN 'sectors'
    WHEN 'GEOGRAPHY'
    THEN 'regions'
    WHEN 'CREDIT_QUALITY'
    THEN 'credit_qualities'
    WHEN 'CURRENCY'
    THEN 'currencies'
  END AS distribution_type,
  ad.effective_start_date,
  COALESCE(ad.effective_end_date, CAST('9999-12-31' AS DATE)) AS effective_end_date,
  tn.code AS item_id,
  ad.taxonomy_node_id,
  ad.percentage AS share
FROM asset_service.asset_distributions_dm AS ad
JOIN asset_service.taxonomy_nodes_dm AS tn
  ON tn.node_id = ad.taxonomy_node_id
WHERE
  tn.disabled_at IS NULL
Lineage · insights.asset_distributions_for_consumers_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.