RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.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
10 / 10
running
Distribution
HASH
Rows
—
State size
—
Created
2026-08-11 22:10
Initialized
2026-08-11 22:10
Fragment flags
LOCALITY_PROVIDERSINKSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
158083 12972 33 running
158084 12972 33 running
158085 12971 33 running
158086 12971 33 running
158087 12973 33 running
158088 12973 33 running
158111 12974 33 running
158112 12974 33 running
158116 12975 33 running
158117 12975 33 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='ai-hub-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.