pnl_by_asset_class_sink__rwm_shim · insights

← cluster insights objects pnl_by_asset_class_sink__rwm_shim

Overview Objects Graph History

table · insights.pnl_by_asset_class_sink__rwm_shim Explain plan ▶

Parallelism

Actors

0 / 0

running

Distribution

—

Rows

State size

—

Created

—

Initialized

—

Fragment flags

—

Actors

Actor	Fragment	Worker	State

sql · insights.pnl_by_asset_class_sink__rwm_shim — click to expand

CREATE VIEW insights.pnl_by_asset_class_sink__rwm_shim AS
SELECT
  account_group_id,
  dim_balance_date,
  position_type AS type,
  taxonomy_node_id AS asset_class,
  currency_code,
  total_gain_loss,
  unrealized_gain_loss,
  realized_gain_loss,
  fair_value_total_gain_loss,
  fair_value_unrealized_gain_loss,
  fair_value_realized_gain_loss
FROM insights.pnl_by_distribution_mv AS pnl_by_distribution_mv_next
WHERE
  distribution_type = 'asset_classes'

Lineage · insights.pnl_by_asset_class_sink__rwm_shim 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.

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