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

CREATE SINK insights.pnl_by_asset_sink AS
SELECT
  account_group_id,
  dim_balance_date,
  position_type AS type,
  asset_id,
  asset_currency AS asset_currency_code,
  currency_code,
  total_gain_loss,
  unrealized_gain_loss,
  realized_gain_loss,
  fair_value_total_gain_loss,
  fair_value_unrealized_gain_loss,
  fair_value_realized_gain_loss,
  total_gain_loss_asset_currency,
  unrealized_gain_loss_asset_currency,
  realized_gain_loss_asset_currency,
  fair_value_total_gain_loss_asset_currency,
  fair_value_unrealized_gain_loss_asset_currency,
  fair_value_realized_gain_loss_asset_currency
FROM insights.pnl_by_asset_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_gain_loss_by_assets_ft',
  schema='insights',
  type='upsert',
  force_compaction='true',
  primary_key='account_group_id,dim_balance_date,asset_id,type'
)