CREATE SINK alpheya_experience_bff.advisor_kpis_sink AS
SELECT
user_id,
clients_count,
portfolios_count,
accounts_count,
total_financing,
total_relationship_value,
total_net_assets,
total_deposits,
total_aum,
currency_code,
updated_at
FROM alpheya_experience_bff.advisor_kpis_mv AS advisor_kpis_mv_next
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='ai-hub-int-alpheya-exp-bff',
table='advisor_kpis',
schema='advisor_portal_bff',
type='upsert',
force_compaction='true',
primary_key='user_id'
)