| Actor | Fragment | Worker | State |
|---|---|---|---|
| 741844 | 44401 | 51 | running |
| 741845 | 44401 | 51 | running |
| 741846 | 44402 | 51 | running |
| 741847 | 44402 | 51 | running |
| 741848 | 44400 | 51 | running |
| 741849 | 44400 | 51 | running |
| 741862 | 44403 | 51 | running |
| 741863 | 44403 | 51 | running |
| 741864 | 44405 | 51 | running |
| 741865 | 44405 | 51 | running |
| 741866 | 44406 | 51 | running |
| 741867 | 44406 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.account_portfolios_mv
WITH (
backfill_order=FIXED(olap.portfolios_dm -> olap.account_to_portfolios_dm)
) AS
SELECT
atp.account_id,
JSONB_AGG(JSONB_BUILD_OBJECT('id', p.portfolio_id, 'name', p.name, 'number', p.number)) AS portfolios,
CAST(COUNT(*) AS INT) AS portfolio_count
FROM olap.account_to_portfolios_dm AS atp
JOIN olap.portfolios_dm FOR SYSTEM_TIME AS OF PROCTIME() AS p
ON p.portfolio_id = atp.portfolio_id AND p.disabled_at IS NULL
JOIN insights.open_accounts_mv AS oa
ON oa.account_id = atp.account_id
WHERE
atp.disabled_at IS NULL AND atp.effective_end_date IS NULL
GROUP BY
atp.account_id