| Actor | Fragment | Worker | State |
|---|---|---|---|
| 745888 | 63424 | 51 | running |
| 745889 | 63424 | 51 | running |
| 745890 | 63425 | 51 | running |
| 745891 | 63425 | 51 | running |
| 746175 | 63426 | 51 | running |
| 746176 | 63426 | 51 | running |
| 746177 | 63428 | 51 | running |
| 746178 | 63428 | 51 | running |
| 746179 | 63427 | 51 | running |
| 746180 | 63427 | 51 | running |
| 746181 | 63429 | 51 | running |
| 746182 | 63429 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_user_accounts_mv AS
SELECT
user_accounts.user_id,
user_accounts.account_id,
MAX(user_accounts.updated_at) AS updated_at
FROM (
SELECT
utm.user_id,
tta.account_id,
tta.updated_at
FROM authz.active_teams_memberships_mv AS utm
JOIN authz.team_to_accounts_mv AS tta
ON tta.team_id = utm.team_id
WHERE
utm.access_type = 'DIRECT'
) AS user_accounts
GROUP BY
user_accounts.user_id,
user_accounts.account_id