CREATE SINK insights.portfolios_sink AS
SELECT
p.portfolio_id,
st.type AS service_type
FROM olap.portfolios_dm AS p
LEFT JOIN olap.service_types_dm AS st
ON st.service_type_id = p.service_type_id
WHERE
p.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='portfolios_dm',
schema='insights',
type='upsert',
force_compaction='true',
primary_key='portfolio_id'
)