RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

← cluster insights objects asset_distributions_week_binned_mv
Overview Objects Graph History
materialized view · insights.asset_distributions_week_binned_mv Explain plan ▶
Parallelism
2
Actors
12 / 12
running
Distribution
HASH
Rows
41,888
State size
9.3 MiB
Created
2026-08-25 13:00
Initialized
2026-08-25 12:59
Fragment flags
LOCALITY_PROVIDERMVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
165976 19903 33 running
165977 19903 33 running
165978 19904 33 running
165979 19904 33 running
165980 19905 33 running
165981 19905 33 running
165982 19906 33 running
165983 19906 33 running
165984 19907 33 running
165985 19907 33 running
165986 19902 33 running
165987 19902 33 running
sql · insights.asset_distributions_week_binned_mv — click to expand 
CREATE MATERIALIZED VIEW insights.asset_distributions_week_binned_mv AS
SELECT
  ad.asset_id,
  ad.distribution_type,
  ad.effective_start_date,
  ad.effective_end_date,
  ad.taxonomy_node_id,
  ad.taxonomy_code,
  ad.share,
  spine.dim_value_week
FROM insights.asset_distributions_for_consumers_mv AS ad
JOIN (
  SELECT DISTINCT
    asset_id,
    CAST(DATE_TRUNC('WEEK', dim_value_date) AS DATE) AS dim_value_week
  FROM insights.position_asset_values_mv AS position_asset_values_mv_next
) AS spine
  ON spine.asset_id = ad.asset_id
  AND spine.dim_value_week >= CAST(DATE_TRUNC('WEEK', ad.effective_start_date) AS DATE)
  AND spine.dim_value_week <= ad.effective_end_date
Lineage · insights.asset_distributions_week_binned_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.