| Actor | Fragment | Worker | State |
|---|---|---|---|
| 54192 | 2571 | 3 | running |
| 54193 | 2571 | 3 | running |
| 54194 | 2572 | 3 | running |
| 54195 | 2572 | 3 | running |
| 54196 | 2573 | 3 | running |
| 54197 | 2573 | 3 | running |
CREATE MATERIALIZED VIEW adib_rm.activity_transaction_account_portfolio_links_mv AS
SELECT
t.transaction_id,
atp.portfolio_id
FROM adib_rm.sdk_activity_transactions_merged_mv AS t
JOIN olap.account_to_portfolios_dm AS atp
ON atp.account_id = t.account_id
AND atp.disabled_at IS NULL
AND atp.effective_start_date <= t.transaction_valuation_date
AND (
atp.effective_end_date IS NULL
OR atp.effective_end_date > t.transaction_valuation_date
)
WHERE
t.order_id IS NULL