CREATE SINK alpheya_agent.transactions_sink AS
SELECT
transaction_id,
account_id,
portfolio_id,
asset_id,
transaction_type,
transaction_type_id,
currency_code,
quantity,
unit_price,
gross_value,
net_value,
valuation_date,
settlement_date,
order_id,
external_reference,
description
FROM alpheya_agent.transactions_mv
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='ai-hub-int-alpheya-agent',
table='transactions',
schema='derived',
type='upsert',
force_compaction='true',
primary_key='transaction_id'
)