| Actor | Fragment | Worker | State |
|---|---|---|---|
| 33233 | 10642 | 33 | running |
| 33234 | 10642 | 33 | running |
| 33375 | 10643 | 33 | running |
| 33376 | 10643 | 33 | running |
CREATE MATERIALIZED VIEW insights.asset_distributions_sink_input_mv AS
SELECT
asset_id,
distribution_type,
effective_start_date,
NULLIF(effective_end_date, CAST('9999-12-31' AS DATE)) AS effective_end_date,
JSONB_OBJECT_AGG(item_id, share) AS distribution,
JSONB_OBJECT_AGG(item_id, taxonomy_node_id) AS taxonomy_node_ids
FROM insights.asset_distributions_for_consumers_mv AS asset_distributions_for_consumers_mv_next
GROUP BY
asset_id,
distribution_type,
effective_start_date,
effective_end_date