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

CREATE MATERIALIZED VIEW alinma_bff.report_position_daily_mv AS
SELECT
  pag.portfolio_id,
  pag.type AS account_group_type,
  ps.dim_balance_date,
  ps.currency_code,
  ps.market_value,
  ps.fair_value,
  ps.accrued_value,
  ps.relationship_value,
  ps.fair_relationship_value,
  ps.market_value_system_currency,
  ps.fair_value_system_currency,
  ps.accrued_value_system_currency,
  ps.relationship_value_system_currency,
  ps.fair_relationship_value_system_currency
FROM insights.portfolio_to_account_groups_mv AS pag
JOIN insights.position_summary_mv AS ps
  ON ps.account_group_id = pag.account_group_id
  AND ps.position_type = 'POSITION'
  AND ps.source_entity_type = 'portfolio'