| Actor | Fragment | Worker | State |
|---|---|---|---|
| 157073 | 16787 | 33 | running |
| 157074 | 16787 | 33 | running |
| 157958 | 16781 | 33 | running |
| 157959 | 16781 | 33 | running |
| 157960 | 16782 | 33 | running |
| 157961 | 16782 | 33 | running |
| 157974 | 16783 | 33 | running |
| 157975 | 16783 | 33 | running |
| 157999 | 16785 | 33 | running |
| 158000 | 16785 | 33 | running |
| 158001 | 16784 | 33 | running |
| 158002 | 16784 | 33 | running |
CREATE MATERIALIZED VIEW insights.private_asset_valuations_mv AS
SELECT
v.asset_id,
v.fact_date,
v.market_value_currency,
v.market_value * COALESCE(fxm.rate, CASE WHEN v.market_value_currency = 'USD' THEN 1 ELSE NULL END) AS value_system_currency,
CASE
WHEN COALESCE(v.average_cost, 0) = 0
THEN 0
ELSE v.average_cost * COALESCE(
fxc.rate,
CASE
WHEN COALESCE(v.average_cost_currency, v.market_value_currency) = 'USD'
THEN 1
ELSE NULL
END
)
END AS cost_system_currency
FROM olap.private_asset_valuations_ft AS v
LEFT JOIN insights.fx_rates_snapshot_mv AS fxm
ON fxm.source_currency_code = v.market_value_currency
AND fxm.target_currency_code = 'USD'
LEFT JOIN insights.fx_rates_snapshot_mv AS fxc
ON fxc.source_currency_code = COALESCE(v.average_cost_currency, v.market_value_currency)
AND fxc.target_currency_code = 'USD'
WHERE
v.disabled_at IS NULL
AND (
NOT fxm.rate IS NULL OR v.market_value_currency = 'USD'
)
AND (
NOT fxc.rate IS NULL
OR COALESCE(v.average_cost_currency, v.market_value_currency) = 'USD'
OR COALESCE(v.average_cost, 0) = 0
)