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
326
State size
64.2 KiB
Created
2026-08-13 17:22
Initialized
2026-08-13 17:22
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
736991 52061 51 running
736992 52061 51 running
737139 52059 51 running
737140 52059 51 running
737141 52058 51 running
737142 52058 51 running
737143 52060 51 running
737144 52060 51 running
737145 52062 51 running
737146 52062 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.