| Actor | Fragment | Worker | State |
|---|---|---|---|
| 737169 | 52073 | 51 | running |
| 737170 | 52073 | 51 | running |
| 737171 | 52074 | 51 | running |
| 737172 | 52074 | 51 | 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