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
Parallelism
2
Actors
6 / 6
running
Distribution
HASH
Rows
—
State size
—
Created
2026-06-30 21:45
Initialized
2026-06-30 21:45
Fragment flags
SINKSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
54343 2645 3 running
54344 2645 3 running
54345 2646 3 running
54346 2646 3 running
54347 2647 3 running
54348 2647 3 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.portfolios_with_accounts_mv AS pwa
  ON pwa.portfolio_id = m.portfolio_id
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.