CREATE SINK insights.position_by_asset_sink 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
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='adib-int-insights-db',
table='account_group_balances_by_assets_ft',
schema='insights',
type='upsert',
force_compaction='true',
primary_key='account_group_id,dim_balance_date,asset_id,type'
)