CREATE SINK alpheya_agent.portfolios_sink AS
SELECT
portfolio_id,
number,
name,
base_currency_code,
service_type_id,
status_label_id,
opening_date,
closing_date,
created_at,
created_at AS updated_at
FROM olap.portfolios_dm
WHERE
disabled_at IS NULL
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='portfolios',
schema='derived',
type='upsert',
force_compaction='true',
primary_key='portfolio_id'
)