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

← cluster alinma_bff objects unlinked_account_pairs_sink
Overview Objects Graph History
sink · alinma_bff.unlinked_account_pairs_sink Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
—
State size
—
Created
2026-08-14 11:04
Initialized
2026-08-14 11:04
Fragment flags
SINKSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
739764 54420 51 running
739765 54420 51 running
739766 54421 51 running
739767 54421 51 running
sql · alinma_bff.unlinked_account_pairs_sink — click to expand 
CREATE SINK alinma_bff.unlinked_account_pairs_sink AS
SELECT
  COALESCE(
    id,
    ID_FROM_STRING_WITH_PREFIX('unlinked_account_pair', security_account_id || ':' || cash_account_id)
  ) AS id,
  security_account_id,
  security_account,
  cash_account_id,
  cash_account,
  registered_by
FROM alinma_bff.unlinked_account_pairs_mv AS unlinked_account_pairs_mv_next
WITH (
  connector='postgres',
  host='psql-nonprod-uae-derived.postgres.database.azure.com',
  port='6432',
  user='migration_user',
  password='***',
  database='alinma-int-portfolio',
  table='unlinked_account_pairs',
  schema='public',
  type='upsert',
  force_compaction='true',
  primary_key='id'
)
Lineage · alinma_bff.unlinked_account_pairs_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.