| Actor | Fragment | Worker | State |
|---|---|---|---|
| 740260 | 59016 | 51 | running |
| 740261 | 59016 | 51 | running |
| 740262 | 59017 | 51 | running |
| 740263 | 59017 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_account_value_monthly_mv AS
SELECT
account_id,
period_start,
aum,
deposits,
financing
FROM (
SELECT
account_id,
CAST(DATE_TRUNC('MONTH', dim_value_date) AS DATE) AS period_start,
aum,
deposits,
financing,
ROW_NUMBER() OVER (
PARTITION BY account_id, CAST(DATE_TRUNC('MONTH', dim_value_date) AS DATE)
ORDER BY dim_value_date DESC
) AS rn
FROM alinma_bff.advisor_kpi_account_value_daily_mv AS advisor_kpi_account_value_daily_mv_next
) AS t
WHERE
t.rn = 1