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

← cluster insights objects portfolio_to_account_groups_sink
Overview Objects Graph History
sink · insights.portfolio_to_account_groups_sink Explain plan ▶
Parallelism
2
Actors
8 / 8
running
Distribution
HASH
Rows
—
State size
—
Created
2026-07-21 10:45
Initialized
2026-07-21 10:45
Fragment flags
SINKSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
100353 17709 26 running
100354 17709 26 running
100355 17710 26 running
100356 17710 26 running
100357 17712 26 running
100358 17712 26 running
100359 17711 26 running
100360 17711 26 running
sql · insights.portfolio_to_account_groups_sink — click to expand 
CREATE SINK insights.portfolio_to_account_groups_sink AS
SELECT
  m.portfolio_id,
  m.account_group_id,
  m.type
FROM insights.portfolio_to_account_groups_mv AS m
JOIN insights.portfolio_account_group_types_mv AS pagt
  ON pagt.portfolio_id = m.portfolio_id AND pagt.type = m.type
WITH (
  connector='postgres',
  host='psql-nonprod-uae-derived.postgres.database.azure.com',
  port='6432',
  user='migration_user',
  password='***',
  database='adib-int-insights-db',
  table='portfolio_to_account_groups_dm',
  schema='insights',
  type='upsert',
  force_compaction='true',
  primary_key='portfolio_id,account_group_id,type'
)
Lineage · insights.portfolio_to_account_groups_sink 3 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.