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

CREATE MATERIALIZED VIEW insights.private_asset_holdings_mv AS
SELECT
  cp.portfolio_id,
  ph.asset_id,
  pa.name,
  pa.local_name,
  pa.category,
  ph.ownership_percentage
FROM olap.private_holdings_dm AS ph
JOIN olap.private_assets_dm AS pa
  ON pa.id = ph.asset_id AND pa.disabled_at IS NULL
JOIN olap.clients_portfolios_dm AS cp
  ON cp.client_id = ph.client_id
  AND cp.owner_type = 'PRIMARY'
  AND cp.disabled_at IS NULL
WHERE
  ph.disabled_at IS NULL