| Actor | Fragment | Worker | State |
|---|---|---|---|
| 158062 | 12969 | 33 | running |
| 158063 | 12969 | 33 | running |
| 158081 | 12970 | 33 | running |
| 158082 | 12970 | 33 | running |
CREATE MATERIALIZED VIEW insights.user_to_account_groups_mv AS
SELECT
uam.user_id,
'account_group_' || MD5(CAST((
uam.user_id || uam.type
) AS BYTEA)) AS account_group_id,
uam.type
FROM insights.user_account_membership_mv AS uam
GROUP BY
uam.user_id,
uam.type