| Actor | Fragment | Worker | State |
|---|---|---|---|
| 99639 | 13399 | 26 | running |
| 99640 | 13399 | 26 | 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