| Actor | Fragment | Worker | State |
|---|---|---|---|
| 157734 | 12812 | 33 | running |
| 157735 | 12812 | 33 | running |
| 157824 | 12813 | 33 | running |
| 157825 | 12813 | 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
GROUP BY
asset_id,
distribution_type,
effective_start_date,
effective_end_date