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

CREATE MATERIALIZED VIEW insights.position_asset_values_mv AS
SELECT
  account_group_id,
  source_entity_type,
  asset_id,
  dim_value_date,
  group_currency,
  COALESCE(position_type, 'POSITION') AS position_type,
  SUM(market_value_group) AS market_value,
  SUM(average_cost_group) AS average_cost,
  SUM(fair_value_group) AS fair_value,
  SUM(accrued_value_group) AS accrued_value,
  SUM(relationship_value_group) AS relationship_value,
  SUM(fair_relationship_value_group) AS fair_relationship_value,
  SUM(market_value_system) AS market_value_system,
  SUM(average_cost_system) AS average_cost_system,
  SUM(fair_value_system) AS fair_value_system,
  SUM(accrued_value_system) AS accrued_value_system,
  SUM(relationship_value_system) AS relationship_value_system,
  SUM(fair_relationship_value_system) AS fair_relationship_value_system
FROM insights.position_values_mv AS position_values_mv_next
GROUP BY
  GROUPING SETS (
    (
      account_group_id,
      source_entity_type,
      asset_id,
      dim_value_date,
      group_currency,
      position_type
    ),
    (account_group_id, source_entity_type, asset_id, dim_value_date, group_currency)
  )