| Actor | Fragment | Worker | State |
|---|---|---|---|
| 54316 | 2643 | 3 | running |
| 54317 | 2643 | 3 | running |
| 54318 | 2644 | 3 | running |
| 54319 | 2644 | 3 | 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