| Actor | Fragment | Worker | State |
|---|---|---|---|
| 736191 | 51878 | 51 | running |
| 736192 | 51878 | 51 | running |
| 736193 | 51875 | 51 | running |
| 736194 | 51875 | 51 | running |
| 736736 | 51873 | 51 | running |
| 736737 | 51873 | 51 | running |
| 736738 | 51872 | 51 | running |
| 736739 | 51872 | 51 | running |
| 736740 | 51871 | 51 | running |
| 736741 | 51871 | 51 | running |
| 736872 | 51874 | 51 | running |
| 736873 | 51874 | 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