CREATE MATERIALIZED VIEW alinma_bff.marketplace_asset_taxonomy_mv AS
SELECT
d.asset_id,
d.distribution_type AS dimension,
d.taxonomy_node_id,
tn.name_en AS node_name_en,
tn.name_ar AS node_name_ar,
d.share AS percentage
FROM insights.asset_distributions_for_consumers_mv AS d
LEFT JOIN asset_service.taxonomy_nodes_dm AS tn
ON tn.node_id = d.taxonomy_node_id
WHERE
d.distribution_type IN ('asset_classes', 'regions')
AND (
d.effective_end_date IS NULL OR d.effective_end_date = CAST('9999-12-31' AS DATE)
)
AND NOT d.share IS NULL