| Actor | Fragment | Worker | State |
|---|---|---|---|
| 53918 | 2400 | 3 | running |
| 53919 | 2400 | 3 | running |
| 53974 | 2397 | 3 | running |
| 53975 | 2397 | 3 | running |
| 53976 | 2398 | 3 | running |
| 53977 | 2398 | 3 | running |
| 53978 | 2399 | 3 | running |
| 53979 | 2399 | 3 | running |
| 53980 | 2401 | 3 | running |
| 53981 | 2401 | 3 | running |
| 53982 | 2402 | 3 | running |
| 53983 | 2402 | 3 | running |
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