| Actor | Fragment | Worker | State |
|---|---|---|---|
| 742477 | 62476 | 51 | running |
| 742478 | 62476 | 51 | running |
| 742483 | 62477 | 51 | running |
| 742484 | 62477 | 51 | running |
| 742512 | 62478 | 51 | running |
| 742513 | 62478 | 51 | running |
| 742514 | 62479 | 51 | running |
| 742515 | 62479 | 51 | running |
| 742528 | 62480 | 51 | running |
| 742529 | 62480 | 51 | running |
| 742531 | 62482 | 51 | running |
| 742532 | 62482 | 51 | running |
CREATE MATERIALIZED VIEW opportunity.portfolio_last_transaction_mv AS
WITH account_last_transaction AS (
SELECT
account_id,
MAX(transaction_valuation_date) AS last_transaction_date
FROM olap.transactions_dm
WHERE
disabled_at IS NULL
GROUP BY
account_id
)
SELECT
atp.portfolio_id,
MAX(t.last_transaction_date) AS last_transaction_date,
'GET_PORTFOLIO_DAYS_SINCE_LAST_TRANSACTION' AS activity_name
FROM account_last_transaction AS t
JOIN insights.open_accounts_mv AS oa
ON oa.account_id = t.account_id
JOIN olap.account_to_portfolios_dm AS atp
ON atp.account_id = t.account_id
AND atp.disabled_at IS NULL
AND atp.effective_end_date IS NULL
JOIN olap.portfolios_dm AS p
ON p.portfolio_id = atp.portfolio_id
AND p.disabled_at IS NULL
AND NOT p.m_is_stub IS TRUE
GROUP BY
atp.portfolio_id