CREATE SINK adib_rm.sdk_home_overview_sink AS
SELECT
client_id,
base_currency_code,
total_market_value,
total_market_value_system_currency,
unrealized_gain_loss,
portfolios,
cash_tiles,
favourites,
top_allocations,
top_allocations_asset_type,
top_allocations_sector
FROM adib_rm.sdk_home_overview_mv
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='adib-int-investor-adib-bff',
schema='investor_adib_bff',
table='sdk_home_overview',
type='upsert',
force_compaction='true',
primary_key='client_id'
)