RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local

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='alinma-qa-insights-db',
  table='portfolios_dm',
  schema='insights',
  type='upsert',
  force_compaction='true',
  primary_key='portfolio_id'
)