| Actor | Fragment | Worker | State |
|---|---|---|---|
| 744087 | 37803 | 51 | running |
| 744088 | 37803 | 51 | running |
| 744089 | 37804 | 51 | running |
| 744090 | 37804 | 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