CREATE SINK adib_rm.sdk_asset_enrichment_sink AS
SELECT
asset_id,
asset_name_en,
asset_name_ar,
asset_type,
issue_currency_code,
sharia_compliance,
ticker,
isin,
latest_price,
latest_price_date,
price_change_pct_1d
FROM adib_rm.sdk_asset_enrichment_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_asset_enrichment',
type='upsert',
force_compaction='true',
primary_key='asset_id'
)