| Actor | Fragment | Worker | State |
|---|---|---|---|
| 157766 | 12775 | 33 | running |
| 157767 | 12775 | 33 | running |
| 157768 | 12774 | 33 | running |
| 157769 | 12774 | 33 | running |
| 157770 | 12776 | 33 | running |
| 157771 | 12776 | 33 | running |
| 157772 | 12778 | 33 | running |
| 157773 | 12778 | 33 | running |
| 157774 | 12777 | 33 | running |
| 157775 | 12777 | 33 | running |
CREATE MATERIALIZED VIEW insights.client_account_direct_mv AS
SELECT
atc.client_id,
atc.account_id,
atc.effective_start_date,
atc.effective_end_date,
CAST('all' AS VARCHAR) AS type
FROM olap.accounts_to_clients_dm AS atc
JOIN insights.open_accounts_mv AS oa
ON oa.account_id = atc.account_id
WHERE
atc.disabled_at IS NULL
AND (
atc.effective_end_date IS NULL
OR atc.effective_end_date > atc.effective_start_date
)