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

← cluster insights objects benchmark_twrr_by_asset_class_sink
Overview Objects Graph History
sink · insights.benchmark_twrr_by_asset_class_sink Explain plan ▶
Parallelism
2
Actors
4 / 4
running
Distribution
HASH
Rows
—
State size
—
Created
2026-08-14 17:32
Initialized
2026-08-14 17:32
Fragment flags
SINKSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
740429 54914 51 running
740430 54914 51 running
740431 54915 51 running
740432 54915 51 running
sql · insights.benchmark_twrr_by_asset_class_sink — click to expand 
CREATE SINK insights.benchmark_twrr_by_asset_class_sink AS
SELECT
  benchmark_id,
  fact_date,
  taxonomy_node_id AS asset_class,
  daily_subperiod_return
FROM insights.benchmark_twrr_by_distribution_mv AS benchmark_twrr_by_distribution_mv_next
WHERE
  distribution_type = 'asset_classes'
WITH (
  connector='postgres',
  host='psql-nonprod-uae-derived.postgres.database.azure.com',
  port='6432',
  user='migration_user',
  password='***',
  database='alinma-int-insights-db',
  table='benchmark_twrr_metrics_by_asset_classes_ft',
  schema='insights',
  type='upsert',
  force_compaction='true',
  primary_key='benchmark_id,fact_date,asset_class'
)
Lineage · insights.benchmark_twrr_by_asset_class_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.