CREATE VIEW insights.position_by_asset_sink__rwm_shim AS
SELECT
account_group_id,
position_type AS type,
dim_balance_date,
asset_id,
currency_code,
market_value,
total_average_cost,
fair_value,
fair_value_system_currency,
accrued_value,
accrued_value_system_currency,
market_value_system_currency,
total_average_cost_system_currency,
market_value_asset_currency,
total_average_cost_asset_currency,
fair_value_asset_currency,
quantity AS asset_quantity,
weight,
fair_value_weight
FROM insights.position_by_asset_mv AS position_by_asset_mv_next