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

CREATE MATERIALIZED VIEW insights.intraday_settled_baseline_mv AS
SELECT
  account_id,
  asset_id,
  currency_code,
  dim_value_date,
  purchased_quantity,
  average_cost_per_unit,
  market_value
FROM (
  SELECT
    account_id,
    asset_id,
    currency_code,
    dim_value_date,
    purchased_quantity,
    average_cost_per_unit,
    market_value,
    ROW_NUMBER() OVER (PARTITION BY account_id, asset_id ORDER BY dim_value_date DESC) AS rn
  FROM olap.holding_values_raw_ft
  WHERE
    type = 'ASSET'
    AND disabled_at IS NULL
    AND COALESCE(m_is_stub, FALSE) = FALSE
    AND dim_value_date <= CURRENT_TIMESTAMP
) AS ranked
WHERE
  rn = 1