| Actor | Fragment | Worker | State |
|---|---|---|---|
| 740641 | 54921 | 51 | running |
| 740642 | 54921 | 51 | running |
| 740643 | 54922 | 51 | running |
| 740644 | 54922 | 51 | running |
| 740645 | 54923 | 51 | running |
| 740646 | 54923 | 51 | running |
| 740647 | 54925 | 51 | running |
| 740648 | 54925 | 51 | running |
| 740649 | 54924 | 51 | running |
| 740650 | 54924 | 51 | running |
| 740651 | 54926 | 51 | running |
| 740652 | 54926 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.advisor_kpi_user_clients_mv AS
SELECT
user_clients.user_id,
user_clients.client_id
FROM (
SELECT
utm.user_id,
ttc.client_id
FROM authz.active_teams_memberships_mv AS utm
JOIN authz.team_to_clients_mv AS ttc
ON ttc.team_id = utm.team_id
WHERE
utm.access_type = 'DIRECT'
) AS user_clients
GROUP BY
user_clients.user_id,
user_clients.client_id