CREATE SINK insights.twrr_by_asset_class_sink AS
SELECT
account_group_id,
dim_balance_date,
item_id AS asset_class,
daily_subperiod_return,
daily_subperiod_fair_value_return AS daily_sub_period_fair_value_return
FROM insights.twrr_by_distribution_mv
WHERE
distribution_type = 'asset_classes'
AND NOT daily_subperiod_return IS NULL
AND NOT daily_subperiod_fair_value_return IS NULL
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_twrr_metrics_by_asset_classes_ft',
schema='insights',
type='upsert',
force_compaction='true',
primary_key='account_group_id,dim_balance_date,asset_class'
)