CREATE SINK insights.accounts_sink AS
SELECT
a.account_id,
a.base_currency_code,
a.is_restricted,
pt.type AS product_type
FROM olap.accounts_dm AS a
LEFT JOIN olap.product_types_dm AS pt
ON pt.product_type_id = a.product_type_id
WHERE
a.closing_date IS NULL AND a.disabled_at IS NULL
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='adib-int-insights-db',
table='accounts_dm',
schema='insights',
type='upsert',
force_compaction='true',
primary_key='account_id'
)