CREATE SINK insights.intraday_position_by_region_sink AS
SELECT
*
FROM insights.intraday_position_by_region_sink__rwm_shim
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='adib-int-insights-db',
table='account_group_balances_intraday_by_regions_ft',
schema='insights',
type='upsert',
force_append_only='true',
force_compaction='true',
primary_key='account_group_id,balance_timestamp,region_label_id,type',
sink_rate_limit=0,
snapshot='false'
)