CREATE SINK insights.private_asset_holdings_sink AS
SELECT
portfolio_id,
asset_id,
name,
local_name,
category,
ownership_percentage
FROM insights.private_asset_holdings_mv AS private_asset_holdings_mv_next
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='alinma-qa-insights-db',
table='private_asset_holdings_dm',
schema='insights',
type='upsert',
force_compaction='true',
primary_key='portfolio_id,asset_id'
)