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

CREATE MATERIALIZED VIEW insights.holding_values_latest_mv AS
SELECT
  account_id,
  asset_id,
  type,
  dim_value_date,
  currency_code,
  purchased_quantity,
  average_cost_per_unit,
  market_value,
  fair_value,
  accrued_value,
  market_value_system_currency,
  average_cost_system_currency,
  fair_value_system_currency,
  accrued_value_system_currency
FROM (
  SELECT
    account_id,
    asset_id,
    type,
    dim_value_date,
    currency_code,
    purchased_quantity,
    average_cost_per_unit,
    market_value,
    fair_value,
    accrued_value,
    market_value_system_currency,
    average_cost_system_currency,
    fair_value_system_currency,
    accrued_value_system_currency,
    ROW_NUMBER() OVER (PARTITION BY account_id, asset_id, type ORDER BY dim_value_date DESC) AS rn
  FROM insights.holding_values_mv AS holding_values_mv_next
) AS ranked
WHERE
  rn = 1