| Actor | Fragment | Worker | State |
|---|---|---|---|
| 157846 | 17914 | 33 | running |
| 157847 | 17914 | 33 | running |
| 157848 | 17915 | 33 | running |
| 157849 | 17915 | 33 | running |
| 157916 | 17916 | 33 | running |
| 157917 | 17916 | 33 | running |
| 157918 | 17917 | 33 | running |
| 157919 | 17917 | 33 | running |
| 157982 | 17918 | 33 | running |
| 157983 | 17918 | 33 | running |
| 158011 | 17920 | 33 | running |
| 158012 | 17920 | 33 | running |
CREATE MATERIALIZED VIEW authz.team_to_portfolios_mv AS
SELECT
portfolio_access.team_id,
portfolio_access.portfolio_id,
MAX(portfolio_access.updated_at) AS updated_at
FROM (
SELECT
etm.team_id,
cp.portfolio_id,
etm.updated_at
FROM olap.entity_to_teams_dm AS etm
JOIN olap.clients_portfolios_dm AS cp
ON etm.entity_id = cp.client_id
WHERE
etm.entity_type = 'CLIENT'
AND etm.disabled_at IS NULL
AND etm.effective_end_date IS NULL
AND cp.disabled_at IS NULL
AND cp.effective_end_date IS NULL
UNION ALL
SELECT
tp.team_id,
app.portfolio_id,
tp.updated_at
FROM authz.team_to_parties_mv AS tp
JOIN authz.active_parties_to_portfolios_mv AS app
ON app.party_id = tp.party_id
UNION ALL
SELECT
etm.team_id,
etm.entity_id AS portfolio_id,
etm.updated_at
FROM olap.entity_to_teams_dm AS etm
WHERE
etm.entity_type = 'PORTFOLIO'
AND etm.disabled_at IS NULL
AND etm.effective_end_date IS NULL
) AS portfolio_access
GROUP BY
portfolio_access.team_id,
portfolio_access.portfolio_id