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

← cluster insights objects flow_asset_values_mv
Overview Objects Graph History
materialized view · insights.flow_asset_values_mv
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
0
State size
—
Created
2026-06-30 21:53
Initialized
2026-06-30 21:53
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
55017 3006 3 running
55018 3006 3 running
55047 3007 3 running
55048 3007 3 running
sql · insights.flow_asset_values_mv — click to expand 
CREATE MATERIALIZED VIEW insights.flow_asset_values_mv AS
SELECT
  account_group_id,
  dim_transaction_date,
  asset_id,
  asset_type,
  CASE WHEN GROUPING(position_type) = 1 THEN 'POSITION' ELSE position_type END AS position_type,
  group_currency,
  SUM(net_value_group) AS net_value_group,
  SUM(net_value_system) AS net_value_system
FROM insights.flow_values_mv
GROUP BY
  GROUPING SETS (
    (
      account_group_id,
      dim_transaction_date,
      asset_id,
      asset_type,
      position_type,
      group_currency
    ),
    (account_group_id, dim_transaction_date, asset_id, asset_type, group_currency)
  )
HAVING
  GROUPING(position_type) = 1 OR NOT position_type IS NULL
Lineage · insights.flow_asset_values_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.