RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

← cluster alpheya_experience_bff objects report_allocation_daily_sink
Overview Objects Graph History
sink · alpheya_experience_bff.report_allocation_daily_sink Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
—
State size
—
Created
2026-08-25 13:37
Initialized
2026-08-25 13:36
Fragment flags
SINKSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
167516 20293 33 running
167517 20293 33 running
167518 20294 33 running
167519 20294 33 running
sql · alpheya_experience_bff.report_allocation_daily_sink — click to expand 
CREATE SINK alpheya_experience_bff.report_allocation_daily_sink AS
SELECT
  portfolio_id,
  account_group_type,
  dim_balance_date,
  distribution_type,
  item_id,
  taxonomy_node_id,
  item_name_en,
  item_name_ar,
  currency_code,
  market_value,
  fair_value,
  market_value_system_currency,
  fair_value_system_currency,
  weight,
  fair_value_weight
FROM alpheya_experience_bff.report_allocation_daily_mv AS report_allocation_daily_mv_next
WITH (
  connector='postgres',
  host='psql-nonprod-uae-derived.postgres.database.azure.com',
  port='6432',
  user='migration_user',
  password='***',
  database='ai-hub-int-alpheya-exp-bff',
  table='report_allocation_daily',
  schema='advisor_portal_bff',
  type='upsert',
  force_compaction='true',
  primary_key='portfolio_id,account_group_type,dim_balance_date,distribution_type,item_id,currency_code'
)
Lineage · alpheya_experience_bff.report_allocation_daily_sink 2 objects
Direct (1-hop) dependencies from rw_depend, across schemas. Click a neighbor to expand its dependencies; ⌘/Ctrl-click opens its page. Drag to pan, scroll to zoom. External source/sink endpoints (Kafka, Iceberg) are not shown.