CREATE SINK insights.flow_summary_sink AS
SELECT
account_group_id,
dim_transaction_date,
position_type AS type,
currency_code,
adjusted_net_flow AS transaction_amount,
adjusted_net_flow_system_currency AS transaction_amount_system_currency,
cumulative_adjusted_netflow
FROM insights.flow_summary_mv
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_transactions_summary_ft',
schema='insights',
type='upsert',
force_compaction='true',
primary_key='account_group_id,dim_transaction_date,type'
)