CREATE SINK alinma_bff.advisor_kpi_period_series_sink AS
SELECT
*
FROM alinma_bff.advisor_kpi_period_series_sink__rwm_shim
WITH (
connector='postgres',
host='psql-nonprod-uae-derived.postgres.database.azure.com',
port='6432',
user='migration_user',
password='***',
database='alinma-int-advisor-portal-bff',
table='advisor_kpi_period_series',
schema='advisor_portal_bff',
type='upsert',
force_compaction='true',
primary_key='user_id,period_kind,period_start,metric',
sink_rate_limit=0,
snapshot='false'
)