intraday_position_by_asset_sink__rwm_shim · insights

← cluster insights objects intraday_position_by_asset_sink__rwm_shim

Overview Objects Graph History

table · insights.intraday_position_by_asset_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.intraday_position_by_asset_sink__rwm_shim — click to expand

CREATE VIEW insights.intraday_position_by_asset_sink__rwm_shim AS
SELECT
  account_group_id,
  position_type AS type,
  change_time AS balance_timestamp,
  asset_id,
  currency_code,
  market_value,
  total_average_cost,
  fair_value,
  fair_value_system_currency,
  accrued_value,
  accrued_value_system_currency,
  market_value_system_currency,
  total_average_cost_system_currency,
  market_value_asset_currency,
  total_average_cost_asset_currency,
  fair_value_asset_currency,
  quantity AS asset_quantity,
  weight,
  fair_value_weight
FROM insights.intraday_position_by_asset_mv AS intraday_position_by_asset_mv_next
WHERE
  NOT change_time IS NULL

Lineage · insights.intraday_position_by_asset_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-adib.adib-rw.svc.cluster.local