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

← cluster insights objects portfolios_sink
Overview Objects Graph History
sink · insights.portfolios_sink Explain plan ▶
Parallelism
2
Actors
8 / 8
running
Distribution
HASH
Rows
—
State size
—
Created
2026-07-21 10:43
Initialized
2026-07-21 10:43
Fragment flags
SINKSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
100256 17688 26 running
100257 17688 26 running
100258 17689 26 running
100259 17689 26 running
100260 17686 26 running
100261 17686 26 running
100262 17687 26 running
100263 17687 26 running
sql · insights.portfolios_sink — click to expand 
CREATE SINK insights.portfolios_sink AS
SELECT
  p.portfolio_id,
  st.type AS service_type
FROM olap.portfolios_dm AS p
LEFT JOIN olap.service_types_dm AS st
  ON st.service_type_id = p.service_type_id
WHERE
  p.disabled_at IS NULL
WITH (
  connector='postgres',
  host='psql-nonprod-uae-derived.postgres.database.azure.com',
  port='6432',
  user='migration_user',
  password='***',
  database='adib-int-insights-db',
  table='portfolios_dm',
  schema='insights',
  type='upsert',
  force_compaction='true',
  primary_key='portfolio_id'
)
Lineage · insights.portfolios_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.