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

← cluster alinma_bff objects marketplace_asset_taxonomy_mv
Overview Objects Graph History
materialized view · alinma_bff.marketplace_asset_taxonomy_mv Explain plan ▶
Parallelism
2
Actors
10 / 10
running
Distribution
HASH
Rows
265
State size
58.0 KiB
Created
2026-08-20 17:01
Initialized
2026-08-20 17:01
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
743639 62626 51 running
743640 62626 51 running
743641 62627 51 running
743642 62627 51 running
743803 62624 51 running
743804 62624 51 running
743805 62623 51 running
743806 62623 51 running
743989 62625 51 running
743990 62625 51 running
sql · alinma_bff.marketplace_asset_taxonomy_mv — click to expand
CREATE MATERIALIZED VIEW alinma_bff.marketplace_asset_taxonomy_mv AS
SELECT
  d.asset_id,
  d.distribution_type AS dimension,
  d.taxonomy_node_id,
  tn.name_en AS node_name_en,
  tn.name_ar AS node_name_ar,
  d.share AS percentage
FROM insights.asset_distributions_for_consumers_mv AS d
LEFT JOIN asset_service.taxonomy_nodes_dm AS tn
  ON tn.node_id = d.taxonomy_node_id
WHERE
  d.distribution_type IN ('asset_classes', 'regions')
  AND (
    d.effective_end_date IS NULL OR d.effective_end_date = CAST('9999-12-31' AS DATE)
  )
  AND NOT d.share IS NULL
Lineage · alinma_bff.marketplace_asset_taxonomy_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.