| Actor | Fragment | Worker | State |
|---|---|---|---|
| 737532 | 52293 | 51 | running |
| 737533 | 52293 | 51 | running |
| 737546 | 52294 | 51 | running |
| 737547 | 52294 | 51 | 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