CREATE SINK insights.pnl_by_sector_sink AS
SELECT
account_group_id,
dim_balance_date,
position_type AS type,
item_id AS sector_label_id,
currency_code,
total_gain_loss,
unrealized_gain_loss,
realized_gain_loss,
fair_value_total_gain_loss,
fair_value_unrealized_gain_loss,
fair_value_realized_gain_loss
FROM insights.pnl_by_distribution_mv
WHERE
distribution_type = 'sectors'
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_gain_loss_by_sectors_ft',
schema='insights',
type='upsert',
force_compaction='true',
primary_key='account_group_id,dim_balance_date,sector_label_id,type'
)