| Actor | Fragment | Worker | State |
|---|---|---|---|
| 738163 | 52702 | 51 | running |
| 738164 | 52702 | 51 | running |
| 738165 | 52703 | 51 | running |
| 738166 | 52703 | 51 | running |
| 738167 | 52704 | 51 | running |
| 738168 | 52704 | 51 | running |
| 738269 | 52706 | 51 | running |
| 738270 | 52706 | 51 | running |
| 738271 | 52705 | 51 | running |
| 738272 | 52705 | 51 | running |
| 738273 | 52707 | 51 | running |
| 738274 | 52707 | 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