CREATE SINK insights.holding_values_sink AS
SELECT
account_id,
asset_id,
currency_code,
dim_value_date,
market_value,
average_cost_per_unit,
purchased_quantity,
average_cost,
type,
fair_value,
accrued_value,
market_value_system_currency,
fair_value_system_currency,
accrued_value_system_currency,
average_cost_per_unit_system_currency
FROM insights.holding_values_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='holding_values_ft',
schema='insights',
type='upsert',
force_compaction='true',
primary_key='account_id,asset_id,dim_value_date,type'
)