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

CREATE MATERIALIZED VIEW insights.settled_cash_balances_mv AS
WITH daily AS (
  SELECT
    account_id,
    currency_code,
    dim_settlement_date,
    SUM(settlement_amount_delta) AS settlement_amount_delta,
    CAST(SUM(transaction_count) AS BIGINT) AS transaction_count
  FROM insights.settled_cash_series_mv AS settled_cash_series_mv_next
  GROUP BY
    account_id,
    currency_code,
    dim_settlement_date
)
SELECT
  account_id,
  currency_code,
  dim_settlement_date,
  settlement_amount_delta,
  SUM(settlement_amount_delta) OVER (PARTITION BY account_id, currency_code ORDER BY dim_settlement_date) AS settled_cash_balance,
  transaction_count
FROM daily