CREATE SINK adib_rm.holding_candidates_sink AS
SELECT
candidate_id,
source_system,
business_date,
source_account_ref,
source_asset_ref,
account_id,
asset_id,
quantity,
market_value,
market_value_currency,
average_cost_per_unit,
source_revision,
superseded_revision,
reconciled_revision,
updated_at
FROM olap.ibor_holding_candidates
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='adib-qa-investor-adib-bff',
schema='admin_portal_bff',
table='holding_candidates',
type='upsert',
force_compaction='true',
primary_key='candidate_id'
)